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 “void” 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.

173 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
void8622056(None) 
avoid95516681avoid
loid55531491loid
ovoid94811021ovoid
vid77241801v_id
voids95414671voids
acid77533392acid
aid49269072_aid
amid77036352amid
arid57642712arid
aroid65428342aroid
avid88325962avid
avoids104410202avoids
bid67751792_bid
bod67055542bo_d
boil66335182boil
bold75432812bold
bond75334362bond
bovid111011622bovid
caid77837532caid
chid106626402chid
cod69660122co_d
coed77140542coed
coif96337912coif
coil66439652coil
coin66645352coin
coir66327242coir
cold77338772cold
cord76740922cord
devoid1189362devoid
did56850512_did
doit56347852doit
droid74218542droid
fid76847682_fid
foil76433912foil
foin77231562foin
fold86528942fold
fond86330952fond
food86830572food
ford86835492ford
geoid74215762geoid
gid57047262_gid
goad66830982goad
god57449792go_d
gold65430162gold
good66531802good
gowd96519982gowd
grid65829612grid
guid66022822guid
hid76248372_hid
hod76852462ho_d
hoed87837982hoed
hold86235062hold
hood85132332hood
hyoid12612442hyoid
id38941832__id
imid76122292imid
iodid74315532iodid
irid55927172irid
join116724832join
kid86540612_kid
koi77534752koi_
kois85129402kois
laid56439142laid
lid47453512_lid
load56730602load
loids66220702loids
loin46838722loin
lord55032082lord
loud55228042loud
maid75537662maid
mid67354462_mid
mod69054402mo_d
modi76826312modi
moil65534092moil
mold76034332mold
mood76332062mood
myoid11512992myoid
nevoid1098792nevoid
nod47549562no_d
nodi56626742nodi
noil46133242noil
noir46722432noir
od39255242_o_d
odd57725452_odd
oi29061482_oi_
oil37452052_oil
old47033462_old
ootid61416702ootid
oud47439072_oud
ovoids10456922ovoids
oxid12815482oxid
paid75737482paid
pod66351482po_d
poi57244662poi_
poind84217912poind
pois66539042pois
pond75530492pond
pood75934322pood
pyoid11513762pyoid
qaid146023842qaid
quid144922352quid
raid55243072raid
rid46754622_rid
road56332112road
rod47953892ro_d
roil46235292roil
rood56733002rood
said55742112said
skid95720922skid
slid55828982slid
sloid64619712sloid
sod46053702so_d
soil46138832soil
sold54837412sold
solid65025082solid
sord56237202sord
toad55830182toad
tod49457072to_d
toed56137042toed
toil46536282toil
toit46353062toit
told56132202told
vail75432552vail
vain75233002vain
vair75624142vair
valid94618392valid
vapid115614282vapid
veil75523592veil
vein75625752vein
veld85323202veld
vend86626422vend
via65636242v_ia
vide85432752v_ide
vids85627532v_ids
vie65447632v_ie
vied86328632vied
vig75637522v_ig
vim87437022v_im
viol76523592viol
virid94116042virid
viroid10411522viroid
vis66747612v_is
vivid125112312vivid
voe67739052vo_e
voes75432822voes
vogie95116662vogie
voice104915322voice
voiced123910112voiced
voided114011132voided
voider103611552voider
voila84813942voila
voile84719722voile
vole75236982vole
voled95323722voled
volt76439532volt
vomit102622572vomit
vote74728622vote
voted93919142voted
vow96136312vo_w
vowed124424572vowed
vows106626942vows
vox136628152vo_x
whid115418872whid
woad85523942woad
wold85429072wold
wood85329382wood
word89832002word
yid76640822_yid
yod77545502yo_d
yond86122312yond
zoic152316072zoic
zooid15312102zooid

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.266671770.7
2DLD Change Limit298721730.87334217.6
3Display Results1731730.0463760.9
 (SQL Overall)1786911731.185150794.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.