Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “whom” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

132 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
whom12701817(None) 
wham125321691wham
whim126220521whim
who95526771who_
whoa106615201whoa
whomp155011321whomp
whop125520921whop
ahem97225362ahem
ahoy101919182ahoy
atom67824522atom
boom87435672boom
cham115532312cham
chomp144815662chomp
chon96627792chon
chop116024922chop
chow125820992chow
chum116318002chum
dhow116614002dhow
dom69752442_dom
doom76430072doom
from96923922from
glom75424382glom
ham86363282_ham
hem86148732_hem
him86247652_him
hm78126732_h_m
hmm106218992_hmm
ho510258272_ho_
hob87550922_hob
hod76852462_hod
hoe67562722_hoe
hog78049062_hog
holm95628102_holm
home98042442_home
homo96126472_homo
homy126623222_homy
hon67759382_hon
hop87554592_hop
hos68364192_hos
hot67776052_hot
how97252432_how
hoy97447912_hoy
hum85542932_hum
khoum1476632khoum
loom67035052loom
mho86624622mho_
mhos95517772mhos
mom78853162_mom
nom510450642_nom
ohm86523012oh_m
oho66534382oho_
om48553002__om
phon95925382phon
phot95534352phot
pom78249912_pom
prom87631692prom
rho65924832rho_
rhomb12399802rhomb
rhos76319062rhos
rom59855632_rom
room66235082room
sham96436352sham
shim95827842shim
shmo95318092shmo
shod86225052shod
shoe75933432shoe
shog86025132shog
shoo75929882shoo
shop95629832shop
shot76150242shot
show106229182show
som59153802_som
them97427042them
tho67433962tho_
thou76722212thou
tom514358052_tom
toom66532932toom
wahoo112413082wahoo
warm95935672warm
wha96422072wh_a
whamo135511262whamo
whams135515642whams
whap125119642whap
what105434072what
whee105429592whee
whelm134611982whelm
when105723042when
whet105133782whet
whew137618782whew
whey135018712whey
whid115418872whid
whig115516422whig
whilom1436132whilom
whims134515332whims
whin105225692whin
whip125521842whip
whir105519282whir
whit104834172whit
whiz195919942whiz
whole114418092whole
whomps16457602whomps
whomso1434132whomso
whoof144612692whoof
whoop134211442whoop
whops135013932whops
whore116018042whore
whorl114612452whorl
whort114623692whort
whose114914532whose
whoso11509222whoso
whump154910042whump
whup125714162whup
why126920012wh_y
whys137011662whys
wo510447762w_o_
woe66651242w_oe
wog76242732w_og
wok106334172w_ok
womb117022232w_omb
won66252062w_on
woo66949802w_oo
wood85329382wood
woof106532422woof
wool76427372wool
woos76238802woos
wop87145132w_op
worm96129482worm
wos66953532w_os
wot610467482w_ot
wow96643472w_ow
yom88043442_yom
zoom156722102zoom

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691298720.0931921408.6
2DLD Change Limit298721320.93631914.5
3Display Results1321320.0304400.0
 (SQL Overall)1786911321.059168735.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.