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 “wheyish” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
wheyish194406(None) 
cherish15310462cherish
greyish1435172greyish
wheys145911552whey_s_
whish144512922wh__ish
whitish1635972whitish
whorish1636602whorish
babyish1736513babyish
blemish1436603blemish
boyish142911233_boyish
cheapish1844333cheapish
chemise143211503chemise
chemism16339303chemism
chemist143615003chemist
clayish1547943clayish
coyish143710393_coyish
delish105215613_delish
dryish1336323_dryish
dweebish1742183dweebish
etherish1448273etherish
fetish12310373_fetish
flemish1536373flemish
fogeyish1843843fogeyish
fogyish1735363fogyish
goyish13379013_goyish
grayish1437813grayish
heigh124812543_he_igh
heimish1535463_heimish
heishi1235843_he_ishi
heist87030913_he_ist
hellish13310723_hellish
hennish1336863_hennish
ladyish14287823ladyish
lazyish22265853lazyish
newish1237903_newish
peevish1535783peevish
perish114619063_perish
pixyish2253653pixyish
plenish1239943plenish
relish93916953_relish
sheepish1645413sheepish
sheesh1237813she_esh
sheikh16206993she_ikh
shrewish1744733shrewish
sweetish1445373sweetish
theism1139483the_ism
theist9314763the_ist
thesis94913733thesis_
thievish1743253thievish
toyish122911123_toyish
waggish15207073waggish
waifish1637703waifish
wampish1777293wampish
warmish1538373warmish
waspish1586923waspish
waterish14310533waterish
weakish17217173weakish
wearish132310153wearish
weigh125412513w_e_igh
welsh113110363w_e_lsh
wennish1336243wennish
wettish1335963wettish
wheals124512523wheals_
wheats125013223wheats_
wheels123811713wheels_
wheens124610613wheens_
wheeps14439953wheeps_
whelks16367323whelks_
whelms14377573whelms_
whelps14437843whelps_
whenas124610463whenas_
whens114618763whe_ns_
wheres125917433wheres_
whets115019613whe_ts_
whews145114493whe_ws_
whey135018713whey___
wheyey1834323whey_ey
wheylike2143403wheylike
which163910083wh__ich
whisht154510813wh__isht
whisk154510143wh__isk
whist115322953wh__ist
whitefish2143073whitefish
wholism1535873wholism
whoosh15244353wh_oosh
whosis1237163whosis_
whydah1942953wh_ydah
whys137011663wh_y_s_
widish13419363w_idish
wildish1446853wildish
wimpish1765683wimpish
winish124212263w_inish
wish107228733w___ish
wispish1575643wispish
woggish15276673woggish
wolfish1636933wolfish
wormish1537163wormish
zanyish2235903zanyish

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.1701051123.5
2DLD Change Limit134027986.97019229.1
3Display Results98980.0303266.7
 (SQL Overall)178691987.17024922.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.