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

88 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
cheerily165542(None) 
cheekily2053471cheekily
cheerly15417601cheer_ly
cheesily1654411cheesily
charily15310282ch_arily
cheerier1348002cheerier
cheering143612702cheering
cheerio12379312cheeri_o
cheerios13317582cheerios
cheery144913152cheer__y
chestily1645522chestily
creepily1574952creepily
eerily92913562__eerily
leerily1037632_leerily
sheerly13337702sheer_ly
wheezily2642302wheezily
aerily93017013__aerily
beefily1535613_beefily
blearily1365953blearily
breezily2243653breezily
celerity1347643celerity
chancily1845243chancily
charity15311023ch_arity
chattily1634603chattily
cheaply1735023ch_eaply
cheekier1735103cheekier
cheeking18349083cheeking
cheeky18448613chee__ky
cheeping16329553cheeping
cheer105420383cheer___
cheered133713293cheer_ed
cheerer123511753cheer_er
cheerers13319543cheerers
cheerful1643983cheerful
cheerfully2192703cheerfully
cheeriest1438213cheeriest
cheerled14105703cheerled
cheero114712933cheer__o
cheeros123711633cheer_os
cheers114518913cheer__s
cheesier1335963cheesier
cheesing14349413cheesing
cheesy14419193chee__sy
cherish15310463ch_erish
cherries131812983cherries
cherry144810763ch_er_ry
cherty144612473ch_er_ty
chervil1534953chervil_
chervils1644553chervils
chiefly1834103chie_fly
chillily1644113chillily
chirpily1843773chirpily
choppily2044133choppily
chubbily2042913chubbily
chummily2042843chummily
chunkily2043083chunkily
clearly1236663clear_ly
clerisy1246823c_lerisy
clerkly1643573c_lerkly
cleverly1643463clever_ly
comelily1546693comelily
covertly1655763covertly
creakily1735393creakily
creamily1536363creamily
deerfly1443983_deerfly
drearily1236083drearily
fierily1339023_fierily
fleecily1644013fleecily
greedily1345183greedily
headily1478623_headily
heartily1436563_heartily
heavily1665903_heavily
heftily1635763_heftily
hoarily1338973_hoarily
merrily1238633_merrily
needily1166323_needily
queerly1934233queer_ly
reedily1179613_reedily
seedily1178583_seedily
sheering123715103sheering
sleepily1344823sleepily
speedily1465183speedily
tearily10311153_tearily
verily122616053__verily
waterily1438783waterily
wearily1338783_wearily
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.423422437.4
2DLD Change Limit146162887.20020300.3
3Display Results88880.0501760.0
 (SQL Overall)178691887.67323288.3
 
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.