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

113 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
utterly103544(None) 
bitterly1335602bitterly
butterfly1742952butterfly
buttery124311192butter_y
guttery11427762gutter_y
latterly1136062latterly
utter54218762utter__
uttered82712432uttered
utterer71910462utterer
utters63817122utter_s
actorly1246413actorly
angerly1137773angerly
artery9911453arter_y
austerely1244133austerely
battery124911813batter_y
butcherly19252653butcherly
butlery12369423butler_y
butter84724233butter__
buttered112712623buttered
butters94521723butter_s
cattery123811603catter_y
cheerly15417603cheerly
cluttery13346323clutter_y
cutely115312803cute_ly
cutlery12448393cutler_y
cutter84521003cutter__
cutters94218963cutter_s
datedly1236023datedly
eagerly1136053eagerly
easterly11246643easterly
eatery95316353eater_y
elderly1154953elderly
fatherly1745073fatherly
ferly115517353__ferly
fluttery14376143flutter_y
gutter73817713gutter__
guttered10259163guttered
gutters83715513gutter_s
huntedly1543583huntedly
innerly1037133innerly
interlay11310043interlay
jittery17346443jitter_y
lately93413843late_ly
littery103710493litter_y
lottery10389833lotter_y
loverly1346973loverly
lubberly1543663lubberly
lumberly1544683lumberly
masterly13317653masterly
mattedly1443883mattedly
mattery123810713matter_y
miserly12329823miserly
motherly16346093motherly
mutedly1345753mutedly
mutely113811653mute_ly
mutter84418883mutter__
muttered112610793muttered
mutterer10218913mutterer
mutters94117143mutter_s
nitery94412173niter_y
notedly1136883notedly
nutter63918053nutter__
nutters74215433nutter_s
nuttily10308633nutt_ily
orderly1135763orderly
otter54423973otter__
otters64021513otter_s
outtell797883outte_ll
outtells896853outtells
overly122411363_overly
pettedly1443893pettedly
pottery123011073potter_y
putter83921443putter__
puttered112611143puttered
putterer10209913putterer
putters94219193putter_s
quarterly2143703quarterly
queerly1934233queerly
rottenly1144153rottenly
ruttily10338613rutt_ily
sheerly13337703sheerly
sisterly1146333sisterly
soberly1236943soberly
sottedly1244303sottedly
southerly1544183southerly
sputtery13366473sputter_y
statedly1245833statedly
stately10310223state_ly
steely93612573_steely
steeply1236293steeply
sternly1037853_sternly
summerly15275103summerly
telly84920823__telly
termly1138433__termly
terry84721873__terry
tetryl935693_tetryl
tottery10388483totter_y
trebly1138973_trebly
twirly12427083_twirly
underlay12147653underlay
unitedly1245793unitedly
unmerry1245023unmerry
untruly1046293untruly
uteri51012983u_ter_i
uterus639203u_terus
utterable1147153utterable
utterers8218653utterers
uttering91613083uttering
waterily1438783waterily
watery123914493water_y
westerly1445553westerly
winterly14306743winterly
writerly1444153writerly

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.406440125.6
2DLD Change Limit1340271136.56320421.6
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.01525472.7
 
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.