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

90 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
raccoon117616(None) 
raccoons1265451raccoons
racoon83814471ra_coon
puccoon1343502puccoon
racon75422142ra_c_on
racoons93912432ra_coons
ratoon64417372ra_toon
rattoon7359242rattoon
rockoon1345652rockoon
aboon74918703_a_boon
accord1178843_accord
accost101112263_accost
account11109043_account
achoo10315083_achoo_
acorn75616623_a_corn
action84719683_action
ancon75718233_anc_on
archon11311753_archon
aswoon947013_aswoon
baboon103613913ba_boon
bacon95620593ba_c_on
balloon93711433balloon
bassoon937613bassoon
bradoon1037353bra_doon
cardoon104813813cardoon
cartoon94114463cartoon
cocoon10312263_cocoon
coon67248943___coon
crampoon1444543crampoon
croon75522783__croon
dacron94310693da_cron
dahoon1039053da_hoon
dragoon935283dra_goon
faction122613333faction
falcon11310293falc_on
fraction1359483fraction
gaboon93211773ga_boon
gadroon938173gadroon
galloon82910643galloon
garcon92912483garc_on
gascon9339723gasc_on
halcyon1543923halcyon
harpoon1238313harpoon
jargoon1545193jargoon
lagoon7410483la_goon
lampoon11267193lampoon
lardoon83410373lardoon
macaroon1246343macaroon
maccoboy1941843maccoboy
macon94519953ma_c_on
macron103615673ma_cron
madzoon1996063madzoon
maroon83118203ma_roon
mascon103612743masc_on
matzoon1896473matzoon
paction112713963paction
patroon92811973patroon
puccoons1443403puccoons
racons84319343ra_cons
radon64620503ra__don
rampion11298583rampion
ramson8310463ra_mson
rancho114310853rancho_
ranchos123911393ranchos
rancor8810373ranc_or
rancors9811373rancors
rancour987133rancour
ration64226013ra_tion
ratoons73815473ra_toons
ratton64116123ra_tton
rattoons8327513rattoons
raucous938303raucous
rayon83815703ra__yon
reaction10612603reaction
reckon123010543r_eckon
recoin84320293r_ecoin
recon75624243r_ec_on
recook125513923r_ecook
recrown12257573recrown
rockoons1445003rockoons
rococo1036813rococo_
rococos1145903rococos
ruction93611613ruction
sacaton938993sacaton
saloon64418023sa_loon
tachyon1544623tachyon
taction93213023taction
traction10412683traction
tycoon1136023_tycoon
zacaton1845633zacaton

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.406440125.6
2DLD Change Limit134027906.61020276.4
3Display Results90900.0303000.0
 (SQL Overall)178691907.04625360.6
 
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.