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

139 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
codriver143591(None) 
codrive1337651codrive_
codriven1444391codriven
codrivers1544861codrivers
codrives1437661codrives
cabdriver1741672cabdriver
coderive1447692coderive_
coderived1644792coderived
coderives1547482coderives
codrove1336422codrove_
conniver1337492conniver
contriver1448342contriver
courier93617892couri_er
cowriter13238882cowriter
driver104714492__driver
nondriver1344862nondriver
arriver10117793_arriver
bedrivel1444083bedrivel
cabdrivers1841593cabdrivers
cadaver1335783cad_aver
carrier93619583carri_er
carver114420143c_ar_ver
charier124317903chari_er
cloddier1234063cloddi_er
coalier93416183coali_er
coarser93211203coar_ser
cobbier133410163cobbi_er
cockier154013623cocki_er
codder104416343cod__der
coddler113710833cod_dler
codeine103815033codeine_
codeines113114523codeines
coder86134223cod___er
codger105814873cod__ger
codices12512583cod_ices
codifier1447163codifier
codriving1645213codriving
coercer1138383coer_cer
coercive1545873coercive_
cognizer2055863cognizer
coiler84421593co__iler
coiner84323783co__iner
collider113410423collider
collier93618153colli_er
colorizer202410623colorizer
combiner14259723combiner
comfier1439163comfi_er
compiler1438373compiler
conceiver1657413conceiver
conciser12310243conciser
confider1438123confider
confiner13311193confiner
conifer123212643co_nifer
connive1238993connive_
connived1436433connived
connivers1436933connivers
connivery1744213connivery
connives1339723connives
consider11310393consider
contrive13311353contrive_
contrived1547993contrived
contrivers1547253contrivers
contrives14311703contrives
copier103722893co_pi_er
corder94322883co_r_der
cordite10315263cordite_
cordites11314623cordites
corer75538873co_r__er
corker124720853co_r_ker
corkier133114303co_rkier
corner84625623co_r_ner
cornier93017093co_rnier
coroner94218203co_roner
corridor1145033corridor
corrie83621223corri_e_
corries94026793corri_es
corrival1346153corrival
coruler9311713co_ruler
corvee114320093co_r_vee
corves115122523co_r_ves
corvet114626933co_r_vet
cosier84423753co_si_er
costive12312843costive_
cottier93814173cotti_er
couriers103213173couri_ers
courser94114803cour_ser
courter94516483cour_ter
courtier1059333courtier
cover105430773co___ver
cowier113616163co_wi_er
cowrie113814283cowri_e_
cowries124218013cowri_es
cowrite123612683cowrite_
cowriters14317283cowriters
cowrites133011593cowrites
cozier173315143co_zi_er
craver114618463c__raver
crier74724463c__ri_er
curdier103312623curdi_er
currier93316703curri_er
curvier123110663c_urvier
depriver1446293depriver
deriver114213913_deriver
diver94827803__d_iver
dodgier10388243dodgi_er
downriver1642663downriver
drier64423963__dri_er
drive95318003__drive_
drivel105110383__drivel
driven105210143__driven
drivers114412793__drivers
drives105117113__drives
drover104614593__drover
forever1338953fo_rever
forgiver1534183forgiver
godlier938893godli_er
gorier73719373go_ri_er
hoarier104211743hoari_er
horrider1236533horrider
iodizer17408663iod_izer
joyrider1942663joyrider
lorimer937753lo_rimer
loriner7511893lo_riner
lowrider1234153lowrider
moorier93113073moori_er
nondrivers1444263nondrivers
podgier11338723podgi_er
redrive112410563redrive_
redriven12226153redriven
redrives122610393redrives
river85731693___river
shriver134712193_shriver
sorrier72313733sorri_er
striver104315203_striver
thriver13479123_thriver
torrider936173torrider
upriver12196933_upriver
wordier112511213wordi_er
worrier102311683worri_er

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621397.70318974.7
3Display Results1391390.0602316.7
 (SQL Overall)1786911398.18621828.9
 
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.