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

100 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
coleseed114740(None) 
coleseeds1244321coleseeds
coalesced1444552coalesced
colessee1098792colessee
colessees11146052colessees
molested11178242molested
allseed835953_allseed
blessed10319493_blessed
caressed1139163caressed
celeste949653celeste_
celestes10310013celestes
cessed94615613c__essed
cheesed133910683chees_ed
chested133811673c_hested
clashed133614013c_lashed
clasped123610443c_lasped
classed104113653c_lassed
cleaned103512003c_leaned
cleared103612463c_leared
cleated103417843c_leated
cleaved134010483c_leaved
cleeked14357733c_leeked
clefted13326753c_lefted
cleped115114113c_le_ped
clerked14326653c_lerked
clewed1225113203c_le_wed
closed95317963c_los_ed
closeted1135613closeted
coalesce1245423coalesce_
coalesces1346043coalesces
coalshed1435013coalshed
coarsened1245143coarsened
coasted104015953co_asted
coerced1238583co_erced
coheaded1536603coheaded
cohered133514693cohe_red
cohosted1436133cohosted
cokehead1845063cokehead
colead94114643col__ead
coleader1139183coleader
coled85540763col___ed
coles76055063coles___
coleslaw1343643coleslaw
colessor1045233colessor
coleuses1039723coleuses
colicweed1742153colicweed
coliseum1244253coliseum
collaged12279973collaged
collared113211143collared
collated113615063collated
collected1447973collected
colleen939543col_leen
colleted113011663colleted
collided12309803collided
collied103316673col_lied
colluded12296463colluded
cologned1237153cologned
colored10313473col_ored
coloured1148313coloured
columned1334923columned
confessed1546053confessed
congeed113212313co_ngeed
congested1338673congested
contested12310693contested
cooeed95917863co__oeed
cooeyed1346893cooe_yed
coredeem1344753coredeem
corseted11311473corseted
coshed124217543co__shed
cosied94819883co__sied
cosseted1178343cosseted
costed95623113co__sted
counseled1245053counseled
coursed104113603cours_ed
covered133315293cove_red
coveted133011523cove_ted
cowered133214653cowe_red
cowshed1637773co_wshed
cozened19349183coze_ned
creeshed1435693creeshed
crested103416533c_rested
fleshed143210263_fleshed
foresee10414333foresee_
foreseen1139103foreseen
foreseer1139013foreseer
foresees11311643foresees
forested12312463forested
gapeseed1243253gapeseed
jonesed1536263jones_ed
leveed104111373__leveed
molester1099373molester
moonseed1154673moonseed
oilseed835783_oilseed
overseed122513353_overseed
pokeweed1842943pokeweed
poleaxed1854823poleaxed
polished1468433polished
rapeseed1144463rapeseed
reseed74823293__reseed
wormseed1442963wormseed

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.436409841.7
2DLD Change Limit1461621006.97020970.2
3Display Results1001000.0333030.3
 (SQL Overall)1786911007.43924020.8
 
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.