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

102 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
wergild123404(None) 
weregild1342821weregild
wergeld1233181wergeld
wergilds1342651wergilds
engild8107612_engild
overgild1336582overgild
regild8149772re_gild
weregilds1441622weregilds
wergelds1342292wergelds
wergelt1138582wergelt
aeried74221863aer_ied
aerily93017013aer_ily
argil65116883_argil_
argils75213623_argils
begird1036823be_gird
berried103714043berried
cervid1239323cervi_d
derail74218813derail_
derailed102410403derailed
derails84216393derails
edgily1136063_edgily
eerily92913563eer_ily
energid948303energi_d
engilds974863_engilds
engird8126973_engird
ervil8310303_ervil_
ervils948773_ervils
ferried113411523ferried
fertile10311733fertile
fervid1337513fervi_d
gerbil938343gerbil_
gerbils1037303gerbils
gild65526513___gild
herald10311343her_ald
herried113514453herried
jerid132316423jer_i_d
jerkily2134623jerkily
jerrid14259143jerri_d
megilp1135833me_gilp
merged104214953merg_ed
merging112711763merging
merrily1238633merrily
nargile847653nargile
nereid7312923nerei_d
nervily1336863nervily
overgilds1445183overgilds
overgilt1239623overgilt
overgird1336183overgird
overmild1436983overmild
pergola1067623pergola
peril75425953per_il_
periled10316323per_iled
perils84121853per_ils
period9314983per_iod
perkily1637813perkily
rebuild1036293rebuild
regilds996673re_gilds
regilt71217493re_gilt
regrind938983regrind
serail64222673serail_
serails73318363serails
serged84118773serg_ed
serging93416673serging
serried82513963serried
servile10310643servile
tergal72912833tergal_
tergite8311003tergite
turgid868023turgi_d
verbid122311313verbi_d
verbile1249863verbile
verged114815163verg_ed
verging123812303verging
verily122616053ver_ily
warily122915093war_ily
weald95615023we__ald
wearied112911803wearied
wearily1338783wearily
wedged125110303wedg_ed
wedgie11428373wedgi_e
wedgier12428283wedgier
wedgies123910213wedgies
wedging13308723wedging
weedily1476123weedily
weevil1295433weevil_
weeviled1533143weeviled
weevils1384683weevils
weevily1694643weevily
weigela1143073weigela
weighed15135933weighed
weird95111283we__ird
weld84727733we___ld
wergelts1253413wergelts
werwolf1644573werwolf
wherried15175013wherried
wild85126513w___ild
wirily123310783wir_ily
wordily1437853wordily
world96915363wor__ld
wormil1138043wormil_
wormils1236733wormils
worried11308693worried
wried95518563w_r_ied

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.390458182.1
2DLD Change Limit1340271025.92322628.2
3Display Results1021020.0462217.4
 (SQL Overall)1786911026.35928100.5
 
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.