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 “whitely” 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
whitely1634647(None) 
whitefly2042511whitefly
whitey154911881white_y
tritely1039002tritely
whiney155012642whine_y
whirly15448862whi_rly
white114920302white__
whited134814082white_d
whiten124111922white_n
whitens13428732whitens
whiter124316392white_r
whites123919882white_s
whitest133710112whitest
whiteys16396152whiteys
whittle13106102whittle
whity145513472whit__y
widely133311032w_idely
wifely15429422w_ifely
wisely122711712w_isely
writerly1444152writerly
acutely1246123acutely
agilely1135123agilely
blithely16104033blithely
brittly12165973brittly
brutely1235933brutely
chastely1635813chastely
chicly16429203chi_cly
chiefly1834103chiefly
chiel104918973chi_el_
chield124610213chi_eld
chiels115115933chi_els
childly1644803childly
chilly144113223chi_lly
chimbly1974593chimbly
chimley1785163chimley
chisel112111943chisel_
chisels12219103chisels
chital114313883chital_
chitty14329433chit_ty
choicely1843823choicely
cicely1338833_cicely
cutely115312803_cutely
direly10311563_direly
finely123011563_finely
finitely1445663finitely
fitly115114973_fit_ly
highly1636823_highly
hilly114422163_hi_lly
hiply134113613_hi_ply
homely145313173_homely
hotel85520753_hotel_
hotels94515513_hotels
hotly115815483_hot_ly
hugely1336803_hugely
irately1047683irately
laithly1335653laithly
lately93413843_lately
likely13328133_likely
lithely1356643_lithely
lively123310813_lively
mutely113811653_mutely
naively1335903naively
nicely1139493_nicely
nitery94412173_nitery
ovately1334433ovately
philately1743963philately
politely1347093politely
primely1457723primely
quietly1945893quietly
rifely123710033_rifely
ripely112511153_ripely
shapely1536893shapely
shiel811023773shi_el_
shield106212973shi_eld
shiels95418923shi_els
shiftily1744553shiftily
shily115222013shi__ly
shingly143210813shingly
shinily13268933shinily
shitty124110063shit_ty
shivery16317023shivery
snidely1136813snidely
stately10310223stately
swithly1634443swithly
thickly19415573thickly
thinly1238673thi_nly
thirdly1444633thirdly
thistly1395963thistly
timely113410113_timely
unitedly1245793unitedly
vilely1239443_vilely
waited103819773waite_d
waiter94321253waite_r
waiters104218623waiters
wastery134610993wastery
watery123914493w_atery
weasely13317853weasely
weigela1143073weigela
weirdly14274493weirdly
westerly1445553westerly
wetly114511713w_et_ly
wheel115515333wh_eel_
wheels123811713wh_eels
wheezy24244523wh_eezy
whelk154311063wh__elk
whelky19314973wh__elky
whelm134611983wh__elm
whelp136012093wh__elp
whereby1842913whereby
whey135018713wh__e_y
wheyey1834323wheye_y
whiffle1933533whiffle
while115418693whi__le
whiled134514133while_d
whiles124418013while_s
whimsey18373893whimsey
whimsy17375223whi_msy
whine116022813whine__
whined134715203whine_d
whiner124516633whine_r
whiners134011573whiners
whines125120103whine_s
whinny15587493whi_nny
whiny144915573whi__ny
whippy19385843whi_ppy
whipray1843403whipray
whirl114913823whi_rl_
whirled14368043whirled
whirler13307603whirler
whirls124710533whi_rls
whirry15477063whi_rry
whiskery21314553whiskery
whiskey20445583whiskey
whisky19455903whi_sky
whispery19284293whispery
whisted144010013whiste_d
whistle13107533whistle
whistled1595783whistled
whistler1496313whistler
whistles14108213whistles
whit104834173whit___
whitecap1842713whitecap
whitened1535173whitened
whitener1435733whitener
whiteout1445583whiteout
whitewall1852773whitewall
whither163510253whither
whitier133311063whitier
whities133113253whities
whitiest14259883whitiest
whiting143311303whiting
whitish1635973whitish
whitlow1642853whitlow
whits115923823whit__s
whitter139110893whitter
whitters14359403whitters
whittled1594913whittled
whittler1495193whittler
whittles1496673whittles
whizzy23274073whi_zzy
wholly15366573wh_olly
wield95213913w_i_eld
wieldy13476183w_i_eldy
wifey144913673w_ife_y
wiggly14559683w_iggly
wildly13328123w_ildly
wilily123310763w_ilily
willy115321913w_i_lly
wily106428813w_i__ly
winery125014283w_inery
winey115325433w_ine_y
winterly14306743winterly
wintery13399753wintery
wirily123310783w_irily
witchy17468593w_itchy
wite75443273w_ite__
wited94727143w_ite_d
wites85536963w_ite_s
withy144813763w_it_hy
witney12356843w_itney
wittily1336173wittily
witty114717013w_it_ty
wontedly1544253wontedly
wriggly15324893wriggly
wrinkly17295753wrinkly
write85522833write__
writer94416513write_r
writers105513493writers
writes94420333write_s

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 Filter1786911340270.453394461.4
2DLD Change Limit1340271896.98319193.3
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.51623774.7
 
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.