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 “engilds” with Change Limit: [1] [2] [3]

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

141 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
engilds97486(None) 
engild8107611engild_
engirds995051engirds
enfolds11136252enfolds
engilded1143982engilded
engines81114462engines
engird8126972engird_
engulfs1143832engulfs
ensiles72714832ensiles
enwinds11255552enwinds
gilds75417522__gilds
regilds996672regilds
ungirds9105302ungirds
wergilds1342652wergilds
angels74416173angel_s
angelus8418463angelus
anginas8310953anginas
angles74426703ang_les
anglos74413913ang_los
anils56326723an_il_s
anvils9219713anvil_s
argils75213623argil_s
begirds1134883begirds
builds9378493_builds
centiles103615813centiles
dentils84115583dentil_s
eagles73819163eag_les
edgily1136063edgil_y
edgings10256243edgings
ediles74016983e_diles
egads74610923e_g_ads
egis56520653e_gi__s
egises7312493e_gises
elds56324853e___lds
emails84412343email_s
enables92813123enables
encinas938723encinas
endings92910443endings
endites83717063endites
endives113710693endives
ends56528523en___ds
energids1045583energi_ds
enfilade1243743enfilade
enfilades1343883enfilades
enfold10137613enfold_
engages92912493engages
engilding1244483engilding
engine71114863engi_ne
engined9119893engined
enginous946493enginous
engirded1143973engirded
engirdle1043223engirdle
engirdles1142623engirdles
engirt71112613engi_rt
english1137953english
englut738453eng_lut
engluts834533engluts
engrails945383engrail_s
engrams1038073engrams
engross837123engross
engs56121393eng___s
engulf1038883engul_f
enhalos1087533enhalos
enigmas1045173enigmas
enisles72312603enisles
enlists749393enlists
enneads834733enneads
enols54718403en_ol_s
enrolls7108093enrolls
enrols61213383enrol_s
ensigns836353ensigns
ensile62616473ensil_e
ensiled82611433ensiled
entails7912823entail_s
entices91616333entices
entires71517783entires
entitles8710663entitles
entoils7810733entoil_s
envied1038833envied_
enviers1036993enviers
envies9314053envi_es
envious1037223envious
enviros1034913enviros
enwind10298083enwind_
equids16439143equi_ds
ervils948773ervil_s
etoiles7411293etoiles
evils84114263e_vil_s
exiles134816403e_xiles
eyelids1135943eyelids
gelds75118343__gelds
gentiles93713523gentiles
gids65933743__gi_ds
gild65526513__gild_
gills64728193__gills
gilts64924263__gilts
gingilis10255593gingilis
girds74816993__girds
golds75421313__golds
guilds8388353_guilds
infields1244013infields
infolds11137023infolds
ingles74420873ing_les
ingulfs1134733ingulfs
inwinds11216273inwinds
lentils73912973lentil_s
magilps1234083magilps
mangolds1235193mangolds
megilps1233563megilps
milds86422053__milds
naiads739013_naiads
nails55730403_nail_s
nills54926673_n_ills
nils46132453_n_il_s
noils55024333_noil_s
overgilds1445183overgilds
pencils113011773pencil_s
pensils92811593pensil_s
pongids11347413pongi_ds
rebuilds1143503rebuilds
regild8149773regild_
renails74917263renail_s
seniles72618023sen_iles
sigils73912363sigil_s
silds65520523__silds
snails64816653snail_s
tenails73713923tenail_s
tenfolds1244413tenfolds
unbinds10267353unbinds
unbuilds1143153unbuilds
unfolds11146803unfolds
ungird887973ungird_
unmolds10135743unmolds
unpiles92112783unpiles
unwinds11286733unwinds
upgirds11103073upgirds
vigils104210193vigil_s
weregilds1441623weregilds
wergelds1342293wergelds
wergild1234043wergild_
wilds94818203__wilds

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271415.90622693.4
3Display Results1411410.0463065.2
 (SQL Overall)1786911416.35828104.9
 
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.