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

107 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
blithered1515612(None) 
blathered15168351blathered
blethered15165431blethered
slithered13136621slithered
bittered112711832b_ittered
blatherer14176712blatherer
blattered12198562blattered
blinkered1644412blinkered
blistered12167682blistered
blither124812172blither__
blithers134711232blither_s
bothered142110392b_othered
brothered1546002brothered
dithered13189292_dithered
flittered13196252flittered
glittered11195402glittered
lathered121512322_lathered
littered92511382_littered
slathered13148542slathered
swithered16135462swithered
withered15169432_withered
altered83215733al_t_ered
bantered113313633bant_ered
bartered113113013bart_ered
battered113315053b_attered
bettered113011833b_ettered
bickered17108003b_ickered
bistered112913323b_istered
bitterer10309773b_itterer
blabbered13184593blabbered
blather125314203blather__
blatherers15175343blatherers
blathers134713793blather_s
blazered2035063bl_azered
blether12459913blether__
blethers13429613blether_s
blighted1546863bligh_ted
blithe115810863blith__e_
blitheful1751973blitheful
blithely16104033blithe_ly
blithering16116123blithering
blithest1338083blithe_st
blitzed19336533blit__zed
blitzer18447663blitzer__
blitzers19417153blitzer_s
blubbered13164113blubbered
blundered1335193blundered
blustered12157263blustered
bolstered1246093bolst_ered
burthened1543963burthened
butchered1744583butchered
buttered112712623b_uttered
chittered15166413chittered
ciphered1637053_ciphered
clattered12178403clattered
clinkered1634773clinkered
cluttered12185943cluttered
coinhered1536593coinhered
ditherer12187763_ditherer
fathered151510433_fathered
feathered16188893feathered
filtered12259043filt_ered
flattered13188623flattered
flichtered1942133flichtered
flickered1943753flickered
fluttered13185943fluttered
frittered13205163frittered
furthered1644473furthered
gathered13149373_gathered
glimmered1543103glimmered
glistered11176293glistered
heathered16149463heathered
inhered11313163__inhered
jittered16267223_jittered
latherer111310443_latherer
leathered13148713leathered
lechered1437523_lechered
lettered92910783_lettered
lichened1435753_lichened
lightered1446283_lightered
limbered13158123_limbered
lingered10129643_lingered
lippered13287953_lippered
lither94520953_lither__
lithoed1137833_lith_oed
litterer82810173_litterer
livered113111633_li_vered
loitered938183loit_ered
mitered103213233_mit_ered
mothered142310103_mothered
murthered1544473murthered
pothered142311043_pothered
skittered1434633skittered
slippered1434823slippered
slither104112983slither__
slithers114212953slither_s
slithery14356703slither_y
slivered12218103sli_vered
smothered1545683smothered
tethered1238493_tethered
tittered9239493_tittered
twittered1333813twittered
waitered1238753wait_ered
weathered16168513weathered
witherer14187953_witherer
witherod15156153_witherod
wuthered15157433_wuthered

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411076.15624145.7
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.62226984.4
 
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.