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

126 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
coheading163662(None) 
coleading1338521coleading
beheading1636162beheading
cheating144014522c_heating
cohering142413842cohe_ring
corrading1338202corrading
heading122919112__heading
beading113221863__beading
breading123515463_breading
cascading1545673cascading
caseating12311743caseating
caveating1539293caveating
ceasing104118263c__easing
ceding104014803c__e_ding
chafing163911493c_h_afing
charing133721323c_h_aring
chasing133715893c_h_asing
chawing164813033c_h_awing
checking20379203c_hecking
cheeking18349083c_heeking
cheeping16329553c_heeping
cheering143612703c_heering
cheesing14349413c_heesing
cheffing2034463c_heffing
chefing16359033c_he_fing
chelating1549363c_helating
chevying2034053c_hevying
chewing163911143c_he_wing
chiding143911593c_h_iding
childing15288503c_hilding
chording15410153c_hording
cleaning113112383c_leaning
clearing113014883c_learing
cleating113518143c_leating
cleaving141389683c_leaving
coaling103722823co__aling
coaming123818323co__aming
coating103525313co__ating
coaxing173511703co__axing
cocreating15310293cocreating
codding124014693co__dding
coding104024793co___ding
coercing1349003co_ercing
cohead123811123cohead___
coheaded1536603cohead_ed
coheads13289233cohead__s
cohobating1845023cohobating
cohosting1546323cohosting
cohousing1535283cohousing
collaging1337933collaging
collaring12310563collaring
collating12312783collating
colliding1338583colliding
colluding1335903colluding
comaking1739993co_making
combating16310163combating
commanding1845923commanding
commending1846633commending
comparing162410583comparing
concaving1737353concaving
concealing1549303concealing
conceding1559343conceding
confiding1638333confiding
congaing1239823conga_ing
congealing1447633congealing
contending1449123contending
cooeeing1137463cooe_eing
cooeying1438153cooe_ying
copyreading2052753copyreading
cording113620823co__rding
corelating13511583corelating
corroding1337943corroding
coshering15510023coshe_ring
covering142215733cove_ring
coveting141912313cove_ting
cowering142514043cowe_ring
cowhiding1943843cowhiding
cozening20188323coze_ning
creaking153414123c_reaking
creaming133413143c_reaming
creasing113314443c_reasing
creating113921953c_reating
crusading1344113crusading
deleading1237773deleading
dogearing1235763dogearing
dreading113712803_dreading
goading103112853go__ading
hading113922943__h_ading
headings133510493__headings
healing113922963__healing
heaping133015853__heaping
hearing113324163__hearing
heating114024323__heating
heaving144114763__heaving
heeding123515063__heeding
herding122915123__herding
kneading1436373_kneading
leading93419553__leading
loading94114613lo__ading
nonending1138003nonending
nonfading1445873nonfading
nonreading1246883nonreading
ochering14219393oche_ring
pleading123011443_pleading
poleaxing1944873poleaxing
pomading1437423po_mading
reading93327213__reading
rehearing132211763rehearing
reheating132314913reheating
rereading111212713rereading
shading123115563_sh_ading
sheafing15329483_sheafing
shealing123415463_shealing
shearing123915903_shearing
sheaving154110253_sheaving
shedding14278113_shedding
shending132511253_shending
spreading1339653spreading
steading103613593_steading
subheading1743793subheading
threading14107593threading
treading103515333_treading
unheeding1446103unheeding
unleading1138673unleading
upheaping1743853upheaping
upheaving1843803upheaving

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411267.51319784.5
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.98222386.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.