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

73 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
corncobs144472(None) 
corncob1345661corncob_
corncribs1542962corncribs
corneous10310032corneous
cornrows1345312cornrows
borneols1046343borneols
broncos11188073bronco_s
caracols12310413caracols
carobs104818103car__obs
cernuous1055013cernuous
coanchors1645733coanchors
coccous1039003co_ccous
cocoas104915743co__coas
cocos95624693co__co_s
conchas144013313co_nchas
conches144019813co_nches
conchos144313963co_nchos
conchs134714903co_nc_hs
concoct10312903co_ncoct
concocts1138633co_ncocts
concord12510343co_ncord
concords1358593co_ncords
concours1239473co_ncours
concurs11311473co_ncurs
concuss1138063co_ncuss
condoes104319203co_ndoes
condoms124214083co_ndoms
condors104018573co_ndors
condos94322333co_ndo_s
confabs1435393co_nfabs
congoes103617303co_ngoes
congos94219883co_ngo_s
congous103615083co_ngous
consols92914073co_nsols
contos84923233co_nto_s
convoys15267023co_nvoys
cooncans1246273cooncans
coracles121811163coracles
coracoid1348153coracoid
coracoids1445833coracoids
corantoes1147653corantoes
corantos10310103coranto_s
cordoba1255743cor_doba
cordobas1345803cor_dobas
cordons104415763cor_dons
cormous11312353cor_mous
corncake1645263corncake
corncakes1745013corncakes
corncrib1443903corncrib
corneas94717003corn_eas
cornels94716663corn_els
corners94723313corn_ers
cornets94820573corn_ets
cornices12713293cornices
corniches1666673corniches
cornichons1743153cornichons
cornicles1368243cornicles
cornpone1246933cornpone
cornpones1347113cornpones
cornrow1245603cornro_w
corns76034763corn___s
cornus84816563corn__us
cornuses10310033cornuses
cornutos1046053cornutos
corymbs1633453cor_ymbs
councils1246973councils
couscous1246683couscous
coxcombs2342353co_xcombs
curacoas1246033curacoas
dornocks1544093dornocks
hobnobs1443603hobn_obs
noncoms1139203no_ncoms
pornos85015253porn_o_s

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 Limit146162737.01320841.6
3Display Results73730.0332212.1
 (SQL Overall)178691737.46923924.4
 
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.