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

108 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
nutmegs1013290(None) 
nutmeg9124611nutmeg_
nutlets74111252nutlets
nutmeat947952nutmeat
nutmeats1044462nutmeats
nutters74215432nutters
outbegs1036482outbegs
bummers133712443bummers
buteos84913413but_eos
butes714535873but_e_s
butlers94518053butlers
butles84423913butle_s
butters94521723butters
buttes84822563butte_s
cummers133713483cummers
cutes79438323cut_e_s
cuteys11569983cut_eys
cuties84927363cutie_s
cutlers94217003cutlers
cutlets94113653cutlets
cutters94218963cutters
duties74921903dutie_s
fumers113613383fu_mers
fumes105224703fu_me_s
fumets114311813fu_mets
futzes184313113futze_s
gummers123712203gummers
gutless82610713gutless
gutters83715513gutters
hummers143813063hummers
hutment1239173hutment
hutments1345603hutments
jutes125125133jut_e_s
kummels15234793kummels
lumens85013973lu_mens
lutes55836663lut_e_s
lutings83311053lutings
lutzes153711923lutze_s
megs75530633___megs
mummers103712843mummers
muskegs14285013muskegs
mutes75033783mut_e_s
mutters94117143mutters
mutuels935943mutuels
namers84517333n_amers
names74833363n_ame_s
nates55238333nat_e_s
natters73718063natters
negs55727363n___egs
netless739863netless
netters73618583netters
neumes83112623neume_s
neuters74212273neut_ers
niters64624213nit_ers
nites55736343nit_e_s
nitres65519333nitre_s
nomes74933123n_ome_s
noters64021003not_ers
notes55034583not_e_s
nucleus956573nucleus
nudes64723293nu_de_s
nudgers9479373nudgers
nudges84114743nudge_s
nudies75217093nudie_s
nuggets936383nuggets
nukes95418123nu_ke_s
numbers113711243numbers
numbs94913093nu_m_bs
numen74216793nu_me_n
nursers74311833nursers
nurses63919353nurse_s
nutates73214973nutates
nutlet64220563nutle_t
nutrias739813nutrias
nuts45032673nut___s
nutsedge1041883nutsedge
nutsedges1142233nutsedges
nutted74316973nutte_d
nutter63918053nutte_r
nuttings9276783nuttings
outages82317323outages
outbeg938733outbeg_
outers64230173out_ers
outings84014753outings
outlets73616363outlets
outmans92413283outmans
outrigs82811263outrigs
outsees72616433outsees
outsets73514923outsets
pummels13236543pummels
putlogs1065083putlogs
puttees93612913puttees
putters94219193putters
putzes174212523putze_s
rumens83611813ru_mens
rummers113513653rummers
summers113616503summers
sutlers73116973sutlers
suttees74114063suttees
tegs56031493__t_egs
tutees6514553tut_ees
unmews11326523_unmews
unpegs9256233_unpegs
unties64326923untie_s
utes45930883_ut_e_s
utters63817123_utters
wuthers133711523wuthers
yutzes18408413yutze_s

Search took 8 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.440406115.9
2DLD Change Limit1340271087.14018771.3
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.62623431.8
 
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.