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

88 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
doctored124562(None) 
doctor938992doctor__
doctoral1146302doctoral
doctorly1443112doctorly
doctors1039992doctor_s
factored1436232factored
hectored1436882hectored
motored1039932mo_tored
proctored1446422proctored
sectored1138072sectored
undoctored1442922undoctored
vectored1435632vectored
anchored1438603anchored
bottomed1344673bottomed
chored125321883__chored
cockered17710213cockered
cocooned1337293cocooned
colored10313473co_lored
contorted1239473contorted
contoured1237303contoured
cored85044223__c_ored
cottered112511733cottered
cottoned1138033cottoned
dackered16116893dackered
declared1248743declared
decoded123212383dec_oded
decolored1345663decolored
decoyed14358333dec_oyed
deplored1237233deplored
detoured1036513d_etoured
detoxed1636103d_etoxed
dickered16117533dickered
dictated1239203dictated
distorted1139373distorted
dittoed936733ditto_ed
doated84118183doat__ed
docked145018333doc__ked
docketed16156583docketed
doctorate1246803doctorate
doctorates1346213doctorates
doctorial1246693doctorial
doctoring1346183doctoring
doctorless1342583doctorless
doddered1234943doddered
dogeared1145793dogeared
doggoned1243883doggoned
doited85016633doit__ed
dolloped1234983dolloped
donnered10307753donnered
doomed104113293do__omed
dormered1255673dormered
dotard839053do_tar_d
doted75227073do_t__ed
dotted84717523do_t_ted
dotterel945063dotterel
dottrel834463do_ttrel
dowered122811553do_wered
ducted104012123duct__ed
encored10412103enc_ored
fostered122210453fostered
honored11310123ho_nored
kotowed1533773ko_towed
kowtowed1941953kowtowed
lectured11127233lectured
locoed94312193loc_o_ed
loitered938183loitered
mentored1138003mentored
monitored1245583monitored
moored93814173mo__ored
mortared1137213mortared
ochered132610283_ochered
ochred12328003_oc_hred
octopod1244893_octopod
odored8399223_o_dored
outbred10311263_outbred
pastored1139973pastored
pictured1346573pictured
portered112311543portered
postured1139493postured
pottered112311663pottered
restored96417193restored
scored94621133_sc_ored
stored75524213__stored
succored13135173succored
tochered1437913tochered
tortured935843tortured
tottered9208703tottered
tutored837553_tutored

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.420425454.8
2DLD Change Limit146162886.56322270.6
3Display Results88880.0332666.7
 (SQL Overall)178691887.01625469.1
 
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.