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

125 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
codrove133642(None) 
codrive1337651codrive
coderive1447692coderive
codriven1444392codriven
codriver1435912codriver
codrives1437662codrives
commove1635962commove
corrode101310572corrode
cowrote12289672cowrote
drove95518062__drove
redrove11249422redrove
approve14116603approve
cadre85419023cadr__e
carve106227753c_ar_ve
chrome133214813c_hrome
cirrose937473cirrose
clodpole1343603clodpole
clove105619443c__love
coarse84813903coar_se
codable12311663codable
coddle104713853cod_dle
code77347733cod___e
codeine103815033codeine
coderived1644793coderived
coderives1547483coderives
codon86522853cod_o_n
codons96119463cod_ons
codrivers1544863codrivers
coelome1139683coelome
coerce10310403coer_ce
coercive1545873coercive
coevolve1642963coevolve
colone85425003co_lone
commode1438123commode
commoved1844763commoved
commoves1736963commoves
comose105016843co_mose
compone136517193compone
compose135716663compose
compote135616463compote
comrade12139213comrade
concave1439373concave
condole102914953condole
condone102616293condone
connive1238993connive
connote9311613connote
console92715983console
contrive13311353contrive
convoke16207173convoke
convolve1644653convolve
cooee74531023co__oee
corbie103618203co_rbie
cordage11310063cordage
cordate10315223cordate
cordite10315263cordite
cordoba1255743cordoba
cordon95017293cordo_n
cordoned12229613cordoned
cordons104415763cordons
cordovan1444293cordovan
core67263113co_r__e
corody12149703co_rody
corona83817403co_rona
coronae94214893co_ronae
coronel94515223co_ronel
coroner94218203co_roner
coronet94227173co_ronet
corpse104013403co_rpse
corrade101111043corrade
corrie83621223co_rrie
corroded12147513corroded
corrodes111310333corrodes
corrody13136143corrody
corrosive1445233corrosive
corse75036183co_r_se
corvee114320093co_rvee
corves115122523co_r_ves
corvet114626933co_r_vet
costive12312843costive
courage10310993courage
course85117783cour_se
cove95837073c___ove
cowpoke1835103cowpoke
cowrie113814283cowr_ie
cowrite123612683cowrite
coyote11411783co_yote
crave105626313c__rave
crone75231333c__rone
crore74922873c__rore
croze164719453c__roze
curve104920023c_ur_ve
dove85131563__d_ove
drave95219273__drave
drive95318003__drive
drone65324983__drone
droved114611643__droved
drover104614593__drover
droves105116673__droves
fordone1149383fordone
godroon946043godroon
grove95219333__grove
improve1435963improve
joyrode1853303joyrode
ladrone83611873ladrone
madrone102812663madrone
misdrove1445433misdrove
morose85116243mo_rose
nodose738883nod_ose
outdrove1236473outdrove
padrone102512073padrone
poove104514303po__ove
porose84818743po_rose
prodrome1346203prodrome
prove104823193__prove
redrive112410563redrive
reprove122911073reprove
rove75136983___rove
shrove125412233_shrove
strove95014793_strove
throve128012393_throve
torose64317693to_rose
towrope1245583towrope
trove85221923__trove
unrove92511683_unrove
updove1234483upd_ove

Search took 7 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.420425454.8
2DLD Change Limit1340271256.03322215.6
3Display Results1251250.0462717.4
 (SQL Overall)1786911256.49927495.2
 
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.