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

69 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
cheesily165441(None) 
cheekily2053471cheekily
cheerily1655421cheerily
cheerly15417602chee_rly
cheesier1335962cheesier
cheesing14349412cheesing
cheesy14419192chees__y
chestily1645522chestily
creepily1574952creepily
wheezily2642302wheezily
beefily1535613_beefily
bheesty1542493bhees_ty
breezily2243653breezily
chancily1845243chancily
charily15310283ch_arily
chattily1634603chattily
cheaply1735023ch_eaply
cheekier1735103cheekier
cheeking18349083cheeking
cheeky18448613chee__ky
cheeping16329553cheeping
cheerier1348003cheerier
cheering143612703cheering
cheerio12379313cheeri_o
cheerios13317583cheerios
cheery144913153chee__ry
cheese113812763chees__e
cheesed133910683chees_ed
cheeses123613103chees_es
cheesiest1436323cheesiest
chervil1534953chervil_
chervils1644553chervils
chesty144610503ch_es_ty
chiefly1834103chie_fly
chillily1644113chillily
chirpily1843773chirpily
choppily2044133choppily
chubbily2042913chubbily
chummily2042843chummily
chunkily2043083chunkily
classily1336623classily
clumsily1544003clumsily
comelily1546693comelily
cosily113613853c__osily
creakily1735393creakily
creamily1536363creamily
crusily12199093c_rusily
dressily1246443dressily
easily9313023__easily
eerily92913563__eerily
fleecily1644013fleecily
greasily1236233greasily
greedily1345173greedily
headily1478623_headily
heavily1665903_heavily
heftily1635763_heftily
horsily1338843_horsily
leerily1037633_leerily
messily12298813_messily
needily1166323_needily
queasily2043693queasily
reedily1179603_reedily
seedily1178583_seedily
sheerly13337703shee_rly
sleepily1344823sleepily
speedily1465173speedily
uneasily1146453uneasily
weedily1476123_weedily
weevily1694643_weevily

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.1701051123.5
2DLD Change Limit146162697.51619446.8
3Display Results69690.0302300.0
 (SQL Overall)178691697.71623158.5
 
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.