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

191 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
whittle1310610(None) 
whistle13107531whistle
whittled1594911whittled
whittler1495191whittler
whittles1496671whittles
brittle9168602brittle
cuittle946402cuittle
kittle104012172_kittle
little63312162_little
shuttle1046102shuttle
skittle1135532skittle
spittle937922spittle
thistle10107802thistle
tittle63613322_tittle
vittle94711752_vittle
wattle94314212w_attle
whiffle1933532whiffle
while115418692whi__le
whistled1595782whistled
whistler1496312whistler
whistles14108212whistles
white114920302whi_t_e
whitely16346472whitely
whitter139110892whitter
whittlers1594332whittlers
whittret1445892whittret
whortle13335942whortle
wintle94014602w_intle
awhile1257793awhi__le
battle85217863_battle
belittle1044053belittle
bhistie1236773bhistie
bottle84916073_bottle
brattle9249253brattle
bristle91910103bristle
brittled11186093brittled
brittler10165983brittler
brittles10178653brittles
brittly12165973brittly
cattle85118903_cattle
chattel12388893chattel
chicle134312543chi_cle
chile105626893chi__le
chipotle1543653chipotle
chital114313883chital_
chitter124112963chitter
chitties13310773chitties
chitty14329433chitt_y
chortle124210443chortle
citole8311503_citole
cuittled1133993cuittled
cuittles1045903cuittles
cuttle84113893_cuttle
dottle74212503_dottle
entitle7610293entitle
epistle957893epistle
fettle93713123_fettle
gristle8169223gristle
guttle74111973_guttle
hantle94318203_hantle
higgle113811743_higgle
hirple11158973_hirple
hirsle9159573_hirsle
hittable1336853_hittable
hitter94419863_hitter
hottie92514383_hottie
hurtle93512943_hurtle
hustle93113993_hustle
intitle7610583intitle
istle52214713__istle
ixtle12168013__ixtle
kettle104311613_kettle
kirtle10309473_kirtle
kittel10368873_kittel
kittled12388193_kittled
kittler11338163_kittler
kittles113012493_kittles
littler7348553_littler
littles73212783_littles
mettle83815723_mettle
mottle84116053_mottle
nettle64514583_nettle
pettle84116053_pettle
philtre12105213philtre
pintle83818263_pintle
pottle84416103_pottle
prattle9208833prattle
rattle64717613_rattle
retitle73913093retitle
scuttle936463scuttle
settle63915663_settle
shingle117711283shingle
shitake1455623shitake
shittah1385153shittah
shitted114212053shitted
shittier1137313shittier
shittim1245133shittim
shitty124110063shitt_y
shuttled1234673shuttled
shuttler1164903shuttler
shuttles1136553shuttles
skittles1245763skittles
spittles1038333spittles
tattle64115653_tattle
thimble1435873thimble
thistles1198233thistles
thistly1395963thistly
throttle1164083throttle
title54721073_ti_tle
tittie63213153_tittie
tittles73413253_tittles
twattle1064273twattle
vittae93911003_vittae
vittled11347343_vittled
vittles103211113_vittles
warstle10328013warstle
wattled113610503w_attled
wattles103814073w_attles
whale115517433wh__ale
wheedle1434823wheedle
wheeple1534853wheeple
whetted14256693whetted
whetter13348803whetter
whiffled2133043whiffled
whiffler2033483whiffler
whiffles2034263whiffles
whiled134514133whi__led
whiles124418013whi__les
whine116022813whi__ne
whinge134311543whi_nge
whipt135317423whipt__
whirl114913823whi_rl_
whirled14368043whi_rled
whirler13307603whi_rler
whirls124710533whi_rls
whirly15448863whi_rly
whist115322953whist__
whisted144010013whisted
whistlers1595163whistlers
whists124613813whist_s
whit104834173whi_t__
whited134814083whi_ted
whitefly2042513whitefly
whiten124111923whi_ten
whitened1535173whitened
whitener1435733whitener
whitens13428733whitens
whiter124316393whi_ter
whites123919883whi_tes
whitest133710113whitest
whitey154911883whi_tey
whiteys16396153whiteys
whither163510253whither
whitier133311063whitier
whities133113253whities
whiting143311303whiting
whitish1635973whitish
whitlow1642853whitlow
whits115923823whi_t_s
whitters14359403whitters
whittling1634383whittling
whittrets1542493whittrets
whity145513473whi_t_y
whole114418093wh__ole
whortles14306743whortles
widdle113814843w_iddle
wiggle113713013w_iggle
wile75944373w_i__le
wimble133211923w_imble
wimple133611363w_imple
windle104617953w_indle
winkle133812833w_inkle
wintled11339843w_intled
wintles103414983w_intles
wite75443273w_i_t_e
withe115220233w_i_the
witted104216813w_itted
wittier103910823w_ittier
wittily1336173w_ittily
wittol935923w_ittol
wittols1035733w_ittols
witty114717013w_itt_y
wrastle10368993wrastle
wrestle10298843wrestle
wriggle12316213wriggle
wrinkle14296923wrinkle
wristlet1138643wristlet
writable1338753writable
write85522833wri_t_e
writhe125310703wri_the
written10336343written

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271915.95322514.2
3Display Results1911910.0633031.7
 (SQL Overall)1786911916.17228951.9
 
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.