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

106 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
thundery153382(None) 
thunder1136961thunder_
thunders1236951thunders
shuddery16263412shuddery
thuggery1642562thuggery
thundered1444572thundered
thunderer1344252thunderer
tindery11389362t_indery
asunder856223asunder_
bindery13459833_bindery
blunder103813153blunder_
blunders113911343blunders
bouldery14295013bouldery
boundary1444753boundary
bounder104215533bounder_
bounders114314113bounders
chancery18366653chancery
chandlery18384423chandlery
chudder14245943chudder_
chudders15235563chudders
chunter123911483chunter_
chunters133910903chunters
cindery13429193_cindery
daunder9348893daunder_
daunders10278473daunders
founder114312573founder_
founders123911673founders
foundry1433913found_ry
funder104016083_funder_
funders113813933_funders
gaudery1234743gau_dery
grindery13255513grindery
gunnery11376373_gunnery
hander104526433_hander_
handers114224333_handers
hennery1335303_hennery
hinder104120063_hinder_
hinders113718503_hinders
hounder113412233hounder_
hounders123111713hounders
hundred1237143_hundred
hunger104015203_hunger_
hungers114013303_hungers
hungry1334973_hun_gry
hunker133917673_hunker_
hunkers143314333_hunkers
hunkey164210883_hunke_y
hunter94817773_hunter_
hunters103915733_hunters
launder8309143launder_
launders9358743launders
laundry1133513laund_ry
maunder10328683maunder_
maunders11348343maunders
nunnery10355303_nunnery
plunder103810503plunder_
plunders11329833plunders
pounder103314003pounder_
pounders113113283pounders
prudery1335243pru_dery
rounder83514603rounder_
rounders92613693rounders
rudery10419033_ru_dery
shinnery14305673shinnery
shudder12297323shudder_
shudders13316643shudders
shunner10358643shunner_
shunners11317743shunners
shunter103611733shunter_
shunters113210753shunters
sounder83315383sounder_
sounders93214113sounders
sunder74019823_sunder_
sunders84120053_sunders
sundry1057943_sund_ry
tannery10388663t_annery
taunter73111453taunter_
taunters8259273taunters
tender74121843t_ender_
tenderly1245293t_enderly
tenders83719723t_enders
thanker14309593thanker_
thankers15297833thankers
thievery1742563thievery
thinker143610683thinker_
thinkers15308703thinkers
thinner10358973thinner_
thinners11327753thinners
thudded1333433thudde_d
thumper14356953thumper_
thumpers15365713thumpers
thunderers1443973thunderers
thundering1544573thundering
thunderous1443613thunderous
thunked15386853thunke_d
tinder73821803t_inder_
tinders84219173t_inders
trumpery1533613trumpery
trundler9256153trundler_
trundlers10215003trundlers
tundra736423t_und_ra
tuner56022683t_un_er_
tuners64417343t_un_ers
turnery10357423t_urnery
tushery1335633t_ushery
under64624213__under_

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621066.17323677.6
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.64226903.2
 
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.