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

154 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
whitish163597(None) 
waifish1637702waifish
wettish1335962wettish
wheyish1944062wheyish
whish144512922wh__ish
whitefish2143072whitefish
whites123919882whites_
whitest133710112whitest
whitier133311062whitier
whities133113252whities
whitiest14259882whitiest
whiting143311302whiting
whits115923822whit_s_
whorish1636602whorish
widish13419362w_idish
winish124212262w_inish
baitfish1645483baitfish
brinish1239963brinish
brutish1237703brutish
cattish12410723cattish
cherish15310463cherish
childish1744393childish
chilis115517873chilis_
chitin113114963chiti_n
chitins122713793chitins
chits105424573chit_s_
chutist1239453chutist
coltish121310933coltish
cultish12139113cultish
dhotis1038973dhotis_
dhutis1035943dhutis_
doltish11118733doltish
elitism939763elitism
elitist7414913elitist
faintish1446193faintish
fairish1338993fairish
fattish1359263fattish
fetish12310373_fetish
finish124613413_finish
goatish1139563goatish
haimish1537753haimish
heimish1535463heimish
hickish1936473_hickish
hippish1736183_hippish
hitch134515473_hit_ch
hits75545133_hit_s_
hottish13117903hottish
iritis63113733iritis_
latish92416173_latish
leftish13197253leftish
loutish1039963loutish
maidish13239553maidish
minish115216303_minish
mitis75425993_mitis_
noirish1037883noirish
otitis63612343otitis_
pettish1238283pettish
rattish10510823rattish
runtish1048693runtish
ruttish1048303ruttish
saltish10312163saltish
shitlist1148723shitlist
shits84731173shit_s_
shittah1385153shittah
shortish1437423shortish
skittish1544503skittish
softish13127813softish
sottish10129443sottish
swainish1444753swainish
sweetish1445373sweetish
swinish1347203swinish
tartish101512633tartish
thickish2044603thickish
thievish1743263thievish
thinnish1454873thinnish
thirtyish1842193thirtyish
titis56023813_titis_
waggish15207073waggish
waiting113618953waiting
waitlist1147743waitlist
waits88333523wait_s_
wampish1777293wampish
wapitis1236473wapitis_
warmish1538373warmish
waspish1586923waspish
weakish17217173weakish
wearish132310153wearish
wennish1336243wennish
whats117718993what_s_
whatsis1335253whatsis
whatsit1345823whatsit
whets115019613whet_s_
which163910083wh__ich
whidah1634803whi_dah
whidahs1743333whidahs
whids125413983whi_ds_
whiffs1835083whiffs_
whigs125612643whi_gs_
whiles124418013whiles_
whiling143511743whiling
whilst1239143whi_lst
whims134515333whi_ms_
whimsy17375223whi_msy
whines125120103whines_
whinier134110633whinier
whiniest14298753whiniest
whining143311673whining
whins114922333whi_ns_
whiplash1942833whiplash
whips134917083whi_ps_
whirls124710533whirls_
whirrs12408593whirrs_
whirs115218093whi_rs_
whisht154510813wh__isht
whisk154510143wh__isk
whisks16497353whisks_
whist115322953wh__ist
whisting15329543whisting
whists124613813whists_
whit104834173whit___
white114920303whit__e
whited134814083whit_ed
whitely16346473whitely
whiten124111923whit_en
whitens13428733whitens
whiter124316393whit_er
whitewash2152703whitewash
whitey154911883whit_ey
whiteys16396153whiteys
whither163510253whither
whitings15287063whitings
whitlow1642853whitlow
whitter139110893whitter
whittle13106103whittle
whity145513473whit__y
wholism1535883wholism
whoosh15244353wh_oosh
whosis1237173whosis_
wildish1446853wildish
wimpish1765693wimpish
wish107228733w___ish
wispish1575643wispish
witch134517563w_it_ch
wites85536963w_ites_
with105730473w_it__h
witing103522823w_iting
wits76044873w_it_s_
woggish15276673woggish
wolfish1636933wolfish
wormish1537163wormish
writes94420333writes_
writing113713893writing
writs86624383writ_s_
zitis145815583_zitis_

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.420425454.8
2DLD Change Limit1340271546.06322105.7
3Display Results1541540.0632444.4
 (SQL Overall)1786911546.54627297.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.