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

163 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
thimbles153602(None) 
thimble1435871thimble_
chimbley2063132chimbley
chimbleys2162232chimbleys
chimblies1845032chimblies
fimbles143510662_fimbles
humbles143215802_humbles
shambles15159042shambles
thistles1198232thistles
thumbless1643432thumbless
timbales12227842t_imbales
timbres11249352t_imbres
trembles1237352trembles
tumbles113816022t_umbles
wimbles143010852_wimbles
ambles105121863__ambles
bibles104617643_bi_bles
bimboes13498733_bimboes
brambles14308973brambles
bumbles134016843_bumbles
chicles143512503chi_cles
chiles115425303chi__les
chimbly1974593chimbl_y
chimbs153910303chimb__s
chimeres153511313chimeres
chimes134922573chim__es
chimlas1437453chim_las
chimley1785163chim_ley
chimleys1883633chim_leys
crimples14308963crimples
crumbles14329683crumbles
dibbles124013333_dibbles
dimples122813213_dimples
dribbles13348393dribbles
drumbles13277723drumbles
edibles1048003edi_bles
fimble133611753_fimble_
foibles1238853foi_bles
fribbles15287713fribbles
fumbles143514413_fumbles
gambles124016203_gambles
ghiblis1353343ghi_blis
gribbles13307363gribbles
grumbles13288873grumbles
higgles123911803_higgles
hirples12149643_hirples
hirsles101510073_hirsles
hobbles143313783_hobbles
hombres14369873_hombres
humble133615053_humble_
humbled153711813_humbled
humbler143411943_humbler
humblers15379803_humblers
humblest15288283_humblest
imbues1037983__imbues
jumbles183013323_jumbles
kibbles153510253_kibbles
limbless12246313_limbless
mumbles133014433_mumbles
nibbles114011693_nibbles
nimble103412943_nimble_
nimbler11358063_nimbler
nimblest1236923_nimblest
nombles113212343_nombles
numbles113814273_numbles
phimoses1537203phimoses
pimples133012423_pimples
quibbles2134223quibbles
rambles113118313_rambles
rimples113114223_rimples
rumbles114018393_rumbles
scumbles1447023scumbles
shamble14149263shamble_
shambled16156153shambled
shimmies15287803shimmies
shingles123111113shingles
similes92915233_similes
simples113014943_simples
stumbles1237493stumbles
tables84524893t__ables
tailles72516473tai_lles
tamales93216153t_amales
taxables1734383taxables
temples112610893t_emples
thebes115914493th_eb_es
themes115319253them__es
thiamines1446383thiamines
thiazoles2142553thiazoles
thieves1346903thi_eves
thills95515383thi__lls
thimbleful2051453thimbleful
thimblefuls2161503thimblefuls
thimblerig1851823thimblerig
thimblerigs1951713thimblerigs
thimblesful2161163thimblesful
thiols95112763thi_ol_s
thirled11328093thi_rled
thirls95012063thi_rl_s
thirties1139723thirties
thistle10107803thistle_
tholes94919783th__oles
thumbed15336173thumb_ed
thumbholes2051893thumbholes
thumbs13377443thumb__s
thuribles1442523thuribles
thymes144810743thym__es
thymines1635613thymines
thymols1533843thymol_s
thymuses1643073thymuses
tickles133416853t_ickles
tiles55542103t_i__les
timbale11248803t_imbale_
timbals11239533t_imbals
timber104012683t_imb_er
timbers113111853t_imbers
timbre10328633t_imbre_
timbrel11306563t_imbrel
timbrels12265343t_imbrels
timeless10239543t_imeless
times75630823t_im__es
tingles83818323t_ingles
tinkles113713923t_inkles
tipples112811253t_ipples
titles63719923t_i_tles
tittles73413253t_ittles
toiles63923513toi__les
tombless1236783t_ombless
tramples122610203tramples
trebles9311443t_rebles
tremble1138003tremble_
trembled1335253trembled
trembler1235363trembler
tremblers1334483tremblers
triable92515393triable_
tribes85119023tri_b_es
trickles143013763trickles
trifles103814823tri_fles
trilbies1037693trilbies
trindles93211683trindles
triples94616873tri_ples
troubles1057203troubles
tsimmes1133673tsim_mes
tuilles72411923tui_lles
tumble103215643t_umble_
tumbled123412243t_umbled
tumbler113412823t_umbler
tumblers123110623t_umblers
twiddles13265613twiddles
twinkles1535073twinkles
tzimmes2033063tzim_mes
umbles103817493__umbles
wambles143714023_wambles
whiffles2034263whiffles
whiles124418013whi__les
whimbrel1842433whimbrel
whimbrels1941833whimbrels
whimsies1635193whimsies
whistles14108213whistles
whittles1496673whittles
wimble133211923_wimble_
wimbled15298153_wimbled
wimples143311173_wimples
yohimbes1841193yohimb_es

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621637.39019778.3
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.87622688.0
 
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.