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

208 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
coactor113912(None) 
coactors1239471coactors
cofactor1545751cofactor
actor71116072__actor
cantor85621522c_antor
captor104914602c_aptor
castor84418532c_astor
chantor123710312chantor
coacher143714122coacher
coact96130582coact__
coacted123611612coacted
coaction12310772coaction
coacts105314332coact_s
coanchor1545252coanchor
coaster94219042coaster
coater84329572coa_ter
coauthor1343462coauthor
cofactors1645932cofactors
compactor17256022compactor
contactor1348432contactor
copastor1246342copastor
doctor938992do_ctor
enactor938032enactor
exactor1636622exactor
factor11911452_factor
locator93110422locator
nonactor1047772nonactor
reactor93011652reactor
tractor9311332tractor
abator84512713aba_tor
actors81016763__actors
adaptor1034943adaptor
alastor739653alastor
boaster94616433boaster
boater84622093boa_ter
cacao95420003c_acao_
cacaos104616183c_acaos
cachou13310623c_achou
cacti9318643c_act_i
cactoid12311033c_actoid
cactus104912233c_actus
candor94516423c_andor
canter85230113c_anter
canto74931013c_anto_
canton85722993c_anton
cantors94620753c_antors
cantos84826973c_antos
capacitor1543473capacitor
captors113914983c_aptors
carter84932273c_arter
carton84522663c_arton
cartop104213563c_artop
caster85232573c_aster
castors94919443c_astors
cater74840723c_a_ter
chador1238673cha_dor
chanter123919733chanter
chantors133710263chantors
chapter144213853chapter
charter123918303charter
chaster124718503chaster
chatter124416643chatter
citator9310123citator
clacker153813773clacker
clamor1049453cla_mor
clangor10426683clangor
clatter94014973clatter
coach125919453coac__h
coached153313843coached
coachers154312303coachers
coaches144018693coaches
coachwork2343283coachwork
coacting133412703coacting
coactions1349743coactions
coactive1598623coactive
coadjutor1951613coadjutor
coalbox1844113coalbox
coaler84121713coa_ler
coalier93416183coalier
coanchors1645733coanchors
coapt96131533coapt__
coapted123911503coapted
coapts104614013coapt_s
coarser93211203coarser
coast75236273coast__
coastal9411043coastal
coasted104015953coasted
coasters104317333coasters
coasts85719143coast_s
coat67558353coa_t__
coated94927043coa_ted
coatee84327223coa_tee
coaters93525793coa_ters
coati75624643coa_t_i
coatis85122603coa_tis
coats75635003coa_t_s
coauthors1444313coauthors
coaxer153912793coa_xer
cocker144320393co_cker
coco87330603co_c_o_
cocoa98517883co_c_oa
cocoon10312263co_coon
cocos95624693co_c_os
codebtor1343973codebtor
coeditor1145723coeditor
cogito939203cogito_
cogitos1037613cogitos
cointer93616723cointer
collator10310373collator
collector1346393collector
color76123743co__lor
colter84625093co_lter
compacter17257883compacter
compactors18256253compactors
concho134414263concho_
conchos144313963conchos
concoctor1246323concoctor
concord12510343conc_ord
concur10411103conc_ur
condor94616973co_ndor
conductor1447213conductor
connector1347923connector
contactors1448843contactors
conto76027173co_nto_
contort91422343co_ntort
contos84923233co_ntos
contour939973co_ntour
contractor1449073contractor
convector1648083convector
coocoo1069693cooc_oo
cooktop1544043cooktop
cooter85128613co_oter
copastors1346993copastors
copter109822013co_pter
coranto9311893coranto_
corantos10310103corantos
corrector1347603corrector
costar85518613co_star
coster84331293co_ster
cottar84613813co_ttar
cotter84926673co_tter
cotton8312993co_tton
coucher144515853coucher
coulter94115603coulter
counter94220153counter
courter94516483courter
couter84930223co_uter
coveter122912063coveter
cracker153114173cracker
crafter124111333crafter
crater85026643cra_ter
craton84517193cra_ton
creator93714443creator
cuatro838433cua_tro
curator9312213curator
doctors1039993do_ctors
donator8310263donator
eductor1035863eductor
ejector16378603ejector
elector93313253elector
enactors1038453enactors
enactory1346143enactory
erector93513813erector
evictor12346363evictor
evocator1346573evocator
exacter1637403exacter
exactors1737013exactors
factors12912123_factors
factory15108343_factory
foetor939563fo_etor
fractur12135563fractur
functor1235203functor
gator64416033_ga_tor
grantor84010933grantor
hector113312653_hector
impactor14265003impactor
lector83514983_lector
lictor83610853_lictor
locater93113603locater
locators102910433locators
monitor9310723monitor
motor75317293mo__tor
nonactors1147873nonactors
nonfactor1445273nonfactor
oater55433733_oa_ter
orator6314533_orator
pastor84817483_pastor
poacher143912323poacher
praetor938973praetor
proctor11310433proctor
raptor83912823_raptor
reactors103212283reactors
realtor73611353realtor
rector84019753_rector
redactor1147023redactor
roaster74116663roaster
rotator7310833rotator
rotor55519733ro__tor
sartor6313883_sartor
sector83415933_sector
stator64015483sta_tor
toaster74414463toaster
tractors10312563tractors
traitor7310123traitor
varactor1345683varactor
vector113212063_vector
viator93211833via_tor
victor113210673_victor

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.406440125.6
2DLD Change Limit1340272086.25021444.3
3Display Results2082080.0762736.8
 (SQL Overall)1786912086.73226543.5
 
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.