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

189 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
whittler149519(None) 
whistler1496311whistler
whitter139110891whitt_er
whittle13106101whittle_
whittled1594911whittled
whittlers1594331whittlers
whittles1496671whittles
brittler10165982brittler
chitter124112962chitt_er
hitter94419862_hitt_er
kittler11338162_kittler
littler7348552_littler
shittier1137312shittier
shuttler1164902shuttler
whetter13348802whett_er
whiffler2033482whiffler
whirler13307602whi_rler
whistle13107532whistle_
whistled1595782whistled
whistlers1595162whistlers
whistles14108212whistles
whitener1435732whitener
whiter124316392whi_t_er
whither163510252whi_ther
whitier133311062whi_tier
whitters14359402whitt_ers
whittret1445892whittret
wittier103910822w_ittier
battler94113383_battler
belittler1142493belittler
bitter84622673_bitt_er
bittier94211663_bittier
bottler94211883_bottler
brittle9168603brittle_
brittled11186093brittled
brittles10178653brittles
chatter124416643chatt_er
chattier1337513chattier
chiller124112183chi_ller
chiseler1335903chiseler
chitters133711173chitt_ers
chitties13310773chitties
chortler13336843chortler
critter94113033critt_er
cuittle946403cuittle_
cuittled1133993cuittled
cuittles1045903cuittles
emitter93211083emitt_er
epistler1044833epistler
fitter94120033_fitt_er
flitter103413903flitt_er
fritter103912773fritt_er
glitter84211803glitt_er
gritter83913353gritt_er
grittier9316263grittier
guttler8369163_guttler
hatter94724873_hatt_er
higgler12369803_higgler
hiller94421633_hi_ller
hinter94021303_hint_er
hitcher153712003_hitcher
hither124417253_hi_ther
hitters104717593_hitt_ers
hostler103411023_hostler
hotter94720083_hott_er
hustler103410753_hustler
jitter133314993_jitt_er
kittle104012173_kittle_
kittled12388193_kittled
kittles113012493_kittles
knitter11348133knitt_er
litter64324853_litt_er
little63312163_little_
littles73212783_littles
mottler94410343_mottler
nettler7349503_nettler
nittier73512243_nittier
omitter9298503omitt_er
phatter123810203phatt_er
philter12108213philt_er
prattler10166343prattler
quitter162910753quitt_er
rattler74012743_rattler
ritter63822423_ritt_er
settler73410653_settler
shatter103615703shatt_er
shifter132911083shift_er
shiftier1436343shiftier
shingler12268633shingler
shirtier1137943shirtier
shitted114212053shitt_ed
shutter103712143shutt_er
shuttle1046103shuttle_
shuttled1234673shuttled
shuttlers1254123shuttlers
shuttles1136553shuttles
sitter63323383_sitt_er
skitter113810403skitt_er
skittle1135533skittle_
skittles1245763skittles
slitter73615873slitt_er
slittier837003slittier
spitter94015183spitt_er
spittle937923spittle_
spittles1038333spittles
tattler73112213_tattler
thistle10107803thistle_
thistles1198233thistles
thistlier1243653thistlier
thither13328103thi_ther
throttler1262863throttler
titter63421163_titt_er
tittle63613323_tittle_
tittles73413253_tittles
twitter10278093twitt_er
vittle94711753_vittle_
vittled11347343_vittled
vittles103211113_vittles
wailer93720323wai__ler
waister103812383waist_er
waiter94321253wai_t_er
warstler11275933warstler
watter93221983w_att_er
wattle94314213w_attle_
wattled113610503w_attled
wattles103814073w_attles
wetter93919443w_ett_er
whaler124611973wh__aler
whatever1742673whatever
wheedler1543543wheedler
wheeler13298773wh_eeler
whether16346623wh_ether
whetted14256693whett_ed
whetters14246653whett_ers
whicker19359773whi_cker
whiffer19105323whi_ffer
whiffle1933533whiffle_
whiffled2133043whiffled
whifflers2142773whifflers
whiffles2034263whiffles
while115418693whi__le_
whiled134514133whi__led
whiles124418013whi__les
whimper17297723whi_mper
whiner124516633whi__ner
whinger1410810913whi_nger
whinier134110633whi_nier
whinnier14255003whinnier
whipper173611383whi_pper
whippier18265823whippier
whirled14368043whi_rled
whirlers14286053whi_rlers
whirlier14175293whirlier
whisker17367933whi_sker
whisper15298013whi_sper
whisted144010013whist_ed
white114920303whi_t_e_
whited134814083whi_t_ed
whitely16346473whitel_y
whiten124111923whi_t_en
whitened1535173whitened
whiteners1535243whiteners
whites123919883whi_t_es
whitey154911883whi_t_ey
whities133113253whi_ties
whitlow1642853whi_tlow
whittling1634383whittling
whittrets1542493whittrets
whizzer2134583whi_zzer
whizzier2233283whizzier
whortle13335943whortle_
whortles14306743whortles
wiftier13297733w_iftier
wiggler123110763w_iggler
willer94021063w_i_ller
winter94222803w_int_er
wintle94014603w_intle_
wintled11339843w_intled
wintles103414983w_intles
wither124321353w_i_ther
withier132910493w_ithier
witted104216813w_itt_ed
wrestler11306993wrestler
wriggler13295263wriggler
wristier1136863wristier
wristlet1138643wristlet
writer94416513wri_t_er
writher134010853wri_ther
written10336343writt_en

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.420425454.8
2DLD Change Limit1461621897.09320606.5
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.59323533.6
 
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.