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

324 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
doctors103999(None) 
doctor938991doctor_
actors81016762_actors
coactors1239472coactors
debtors1038532debtors
decors94017772dec_ors
dockers143715002dockers
doctoral1146302doctoral
doctored1245612doctored
doctorly1443112doctorly
dolors75115312do_lors
donators9310402donators
donors75115792do_nors
doors65022132do__ors
doters74423912do_ters
dotters83715972dotters
eductors1135982eductors
factors12912122factors
foetors1039762foetors
hectors123513262hectors
lectors93415762lectors
lictors93212592lictors
locators102910432locators
motors84616602mo_tors
proctors12311512proctors
rectors93520512rectors
rotors64917952ro_tors
sectors93116442sectors
vectors123212592vectors
victors123311182victors
abators94413083abators
abductors1443273abductors
actor71116073_actor_
adaptors1145253adaptors
adductors1343373adductors
adopters1136693adopters
advocators1663913advocators
anchors123912953anchors
bettors93312473bettors
boaters93419243boaters
bolters94017803bolters
boors74325013bo__ors
bostons9312903bostons
bottoms1136993bottoms
boutons9310783boutons
cantors94620753cantors
captors113914983captors
castors94919443castors
coactor1139123coactor_
coaters93525793coaters
coccous1039003coccous
cockers153618333cockers
cocoas104915743coc_oas
cocoons11310563cocoons
cocos95624693coc_o_s
cofactors1645933cofactors
colors86622373co_lors
colters93522443colters
condors104018573condors
contort91422343contort
contorts101112643contorts
contos84923233conto_s
contours1039653contours
cooters94525723cooters
copters113621283copters
cors66656443__c_ors
costars94218013costars
costers94128333costers
cottars94412243cottars
cotters94323443cotters
cottons9312193cottons
couters93827303couters
dackers143417043dackers
dacrons103211033dacrons
dactyls1333913dactyls
daltons8310403daltons
darters84017603darters
daters74827373d_aters
datos65222783d_ato_s
dattos74311903datto_s
debtor938333debtor_
deckers144413833deckers
decolors1187713decolors
decor84717573dec_or_
decos85522123dec_o_s
decoys123911283dec_oys
defectors15237883defectors
delators92314823delators
depictors1465943depictors
detectors12278303detectors
deters74724683d_eters
detours858043d_etours
diatoms1039073diatoms
dicers94720743dic_ers
dickers144117663dickers
dicots94915793dic_ots
dictators1247363dictators
dictions111812673dictions
dictums1235553dictums
dieters83216433dieters
dilators93213193dilators
dilutors9306653dilutors
diopters1137693diopters
directors1248133directors
distort81120333distort
distorts91112353distorts
dittos74111973ditto_s
doats65224883doat__s
dobbers123513253dobbers
doblons1037043doblons
dobros93910233dobro_s
dobsons1036203dobsons
docents102810803docents
docker134417653docker_
dockets144412243dockets
docks126022313doc__ks
docs75631153doc___s
doctorate1246783doctorate
doctorates1346203doctorates
doctorial1246693doctorial
doctoring1346183doctoring
doctorless1342583doctorless
doctorship1854723doctorship
dodders105511793dodders
dodgers105213823dodgers
dodoes85716103do_does
dodos75819393do_do_s
doers65225713do__ers
doffers14359853doffers
dogdoms1295423dogdoms
dogears937513dogears
doggers104413433doggers
dogtrot947443dogtrot
dogtrots1044693dogtrots
doits66223673doit__s
dojos135111793do_jo_s
dollars83311023dollars
dollops10287963dollops
dolor67617963do_lor_
dolours8438823dolours
dolts65626313dolt__s
donator8310263donator_
donjons1536733donjons
donor64418193do_nor_
doodoos9107623doodoos
dooms85321343do__oms
door56928513do__or_
doowops1363943doowops
doozers17419293doozers
dopers95522483do_pers
dormers104313923dormers
dorpers104113173dorpers
dorrs65520593do__rrs
dors56747603d___ors
dorsers83516303dorsers
dosers75723633do_sers
dossers84516233dossers
dotard839053do_tard
dotards937253do_tards
doter65428623do_ter_
dotes65836693do_t_es
dots55647663do_t__s
dottels8327783dottels
dotter74419343dotter_
dottles83912283dottles
doubters11257393doubters
douceurs1142793douceurs
dousers84817273dousers
dowers104523293do_wers
downers113912773downers
dowsers115013533dowsers
dozers164815423do_zers
duckers143214713duckers
ducts85319893duct__s
ductwork1843553ductwork
ductworks1943353ductworks
dusters84918363dusters
ecotours1044463ecotours
editors839423editors
educators1246993educators
eductor1035863eductor_
ejectors17328663ejectors
electors103013843electors
enactors1038453enactors
erectors103514253erectors
evictors13276853evictors
evocators1446713evocators
exactors1737013exactors
excitors1746093excitors
factor11911453factor_
factory15108343factory
fetors91014473_fetors
foetor939563foetor_
footers104618333footers
fosters104220103fosters
functors1335743functors
gators74115833_gators
goiters84014443goiters
hector113312653hector_
hockers163915913hockers
honors94816793ho_nors
hooters104520473hooters
horrors1078693horrors
ichors11310423_ichors
idolators1046283idolators
indictors1247623indictors
inductors1246223inductors
isochors1355673isochors
jockos19527563jocko_s
jolters143711993jolters
jotters143413803jotters
kotos95717703ko_to_s
kotows13446523ko_tows
kowtows1742763kowtows
lector83514983lector_
lictor83610853lictor_
locaters102710073locaters
locator93110423locator_
lockers133516923lockers
locoes85516583loc_oes
locos75822603loc_o_s
locutory1344273locutory
lofters103912903lofters
loiters74116613loiters
looters74419163looters
lotos54724633lo_to_s
lotters73921063lotters
lottos64613103lotto_s
mentors9314993mentors
mockers153812943mockers
molters93816973molters
monitors10310823monitors
moors74923143mo__ors
mooters93818623mooters
mortars93411523mortars
motor75317293mo_tor_
mottoes93412193mottoes
mottos84615243motto_s
moutons9410313moutons
mucors104410853muc_ors
nectars938463nectars
nestors73614973nestors
nocturn944653nocturn
nocturns1043733nocturns
nocuous946583nocuous
nonactors1147873nonactors
nondoctors1345293nondoctors
nostocs947553nostocs
noters64021003no_ters
oaters65029793_oaters
occurs10136553_occurs
ochers113915303_ochers
ockers123813903_ockers
octads987333_octads
octans81411143_octans
octets839403_octets
octopi1036533_octopi
octopus1144813_octopus
octroi837363_octroi
octrois938333_octrois
octyls11135323_octyls
odors64514283_o_dors
orators7313823orators
ottars64112223_ottars
otters64021513_otters
ottos54714323_otto_s
outers64230173_outers
oxters134813273_oxters
pastors94119003pastors
pontons93315553pontons
porters93722703porters
posters93928013posters
postops11311713postops
potters94024343potters
pottos84615873potto_s
pouters94221873pouters
powters124015663powters
pretors9316803pretors
proctor11310433proctor_
raptors94213353raptors
reactors103212283reactors
rector84019743rector_
rectory123512723rectory
rectos85718783recto_s
redactors1247533redactors
reductors1246523reductors
rhetors1038513rhetors
rockers133916553rockers
rooters74522933rooters
rosters73727543rosters
rotators8310203rotators
rotor55519733ro_tor_
rotos56027883ro_to_s
rotters74421393rotters
routers74822873routers
sartors7314963sartors
scoters93313813scoters
sector83415923sector_
soccers1138393soccers
sopors85215203so_pors
sordors8310003sordors
sorters74221133sorters
sotols63714473so_tols
souters74422603souters
stators73915583stators
succors1137413succors
suitors73012493suitors
tictocs1145903tictocs
tochers123413093tochers
tooters73818773tooters
torpors939383torpors
tors46157383___tors
toters65026363to_ters
totters74618733totters
touters74018353touters
tractors10312563tractors
tutors6912333_tutors
vector113212063vector_
viators102712023viators
victor113210673victor_
victory15326983victory
voters95017443vo_ters
wontons103310533wontons
zosters163015413zosters

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.1531167915.0
2DLD Change Limit1340273246.44020811.6
3Display Results3243240.1232634.1
 (SQL Overall)1786913246.71626606.8
 
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.