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
void8622057(None) 
avoid95516681avoid
loid55531501loid
ovoid94811021ovoid
vid77241821v_id
voids95414681voids
acid77533402acid
aid49269092_aid
amid77036362amid
arid57642722arid
aroid65428342aroid
avid88325972avid
avoids104410202avoids
bid67751822_bid
bod67055552bo_d
boil66335182boil
bold75432812bold
bond75334362bond
bovid111011622bovid
caid77837542caid
chid106626412chid
cod69660132co_d
coed77140542coed
coif96337912coif
coil66439652coil
coin66645352coin
coir66327242coir
cold77338772cold
cord76740922cord
devoid1189362devoid
did56850532_did
doit56347852doit
droid74218542droid
fid76847702_fid
foil76433912foil
foin77231562foin
fold86528942fold
fond86330952fond
food86830572food
ford86835492ford
geoid74215762geoid
gid57047282_gid
goad66830982goad
god57449802go_d
gold65430162gold
good66531802good
gowd96519982gowd
grid65829622grid
guid66022832guid
hid76248392_hid
hod76852472ho_d
hoed87837982hoed
hold86235062hold
hood85132332hood
hyoid12612442hyoid
id38941852__id
imid76122302imid
iodid74315532iodid
irid55927182irid
join116724832join
kid86540632_kid
koi77534762koi_
kois85129412kois
laid56439152laid
lid47453532_lid
load56730602load
loids66220712loids
loin46838722loin
lord55032082lord
loud55228042loud
maid75537672maid
mid67354482_mid
mod69054412mo_d
modi76826322modi
moil65534092moil
mold76034332mold
mood76332062mood
myoid11512992myoid
nevoid1098802nevoid
nod47549572no_d
nodi56626752nodi
noil46133242noil
noir46722432noir
od39255252_o_d
odd57725462_odd
oi29061492_oi_
oil37452062_oil
old47033472_old
ootid61416702ootid
oud47439082_oud
ovoids10456922ovoids
oxid12815492oxid
paid75737492paid
pod66351492po_d
poi57244662poi_
poind84217912poind
pois66539042pois
pond75530492pond
pood75934322pood
pyoid11513762pyoid
qaid146023852qaid
quid144922362quid
raid55243082raid
rid46754642_rid
road56332112road
rod47953902ro_d
roil46235292roil
rood56733002rood
said55742122said
skid95720942skid
slid55828992slid
sloid64619712sloid
sod46053712so_d
soil46138832soil
sold54837412sold
solid65025082solid
sord56237202sord
toad55830182toad
tod49457082to_d
toed56137042toed
toil46536282toil
toit46353062toit
told56132202told
vail75432552vail
vain75233002vain
vair75624142vair
valid94618392valid
vapid115614282vapid
veil75523592veil
vein75625752vein
veld85323202veld
vend86626422vend
via65636252v_ia
vide85432772v_ide
vids85627552v_ids
vie65447642v_ie
vied86328642vied
vig75637532v_ig
vim87437032v_im
viol76523602viol
virid94116042virid
viroid10411522viroid
vis66747622v_is
vivid125112312vivid
voe67739052vo_e
voes75432822voes
vogie95116662vogie
voice104915322voice
voiced123910112voiced
voided114011132voided
voider103611552voider
voila84813942voila
voile84719722voile
vole75236982vole
voled95323722voled
volt76439532volt
vomit102622572vomit
vote74728622vote
voted93919142voted
vow96136312vo_w
vowed124424572vowed
vows106626942vows
vox136628152vo_x
whid115418882whid
woad85523942woad
wold85429072wold
wood85329382wood
word89832002word
yid76640842_yid
yod77545512yo_d
yond86122312yond
zoic152316072zoic
zooid15312102zooid

Search took 3 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 Limit298721731.90615672.6
3Display Results1731730.0434023.3
 (SQL Overall)1786911732.21580673.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.