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

244 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
anchor11391197(None) 
ancho104515301ancho_
anchors123912951anchors
anchos114214891anchos
abhor10411062a_bhor
achoo10315082a_choo
actor71116072a_ctor
ahchoo1445712ahchoo
anaphor1245652anaphor
anchored1438592anchored
anchoret13412452anchoret
anchovy1843952anchovy
ancon75718232anc_on
anther93715062anther
anyhow1544102anyhow
archer115016242archer
archon11311752archon
author939762author
coanchor1545252coanchor
ichor1039482_ichor
incher114114032incher
nacho105414382nacho_
nachos115014182nachos
rancher123013632rancher
rancho114310852rancho_
ranchos123911392ranchos
rancor8810372ranc_or
unanchor1343092unanchor
abator84512713abator
abhors11410623a_bhors
abmho1236793abmho_
abmhos1334973abmhos
accord1178843a_ccord
ache96829823a_ch_e
ached119227833a_ched
aches106132293a_ches
achier113914263a_chier
achy126316093a_ch_y
acorn75616623a_c_orn
actors81016763a_ctors
aether94213673aether
ahoy101919183a__hoy
alachlor1343293alachlor
alcohol1244363alcohol
algor6513053a_lgor
alphorn1246393alphorn
altho86312603altho_
althorn1047763althorn
amphora1446923amphora
analog7159973analog
anaphora1345113anaphora
anaphors1346633anaphors
ancestor1046853ancestor
anchorage1544413anchorage
anchoress1445243anchoress
anchorets1445993anchorets
anchoring1548323anchoring
anchorite1448823anchorite
anchorman1644463anchorman
anchormen1644353anchormen
anchusa1244333anchusa
ancone83916953ancone
andro6314163andro_
andros7313303andros
anear55420323an_ear
anechoic1545373anechoic
anethol1045383anethol
anger66225873an_ger
angler74017863angler
anglo65215373anglo_
anglos74413913anglos
angora71111573an_gora
anion55028813an_ion
ankh111114413ankh__
ankhs12116723ankh_s
annoy869713an_noy
anoa45634473an__oa
anon46134853an__on
another10289153another
answer936893answer
antechoir1453403antechoir
anthem113410343anthem
anthers103715203anthers
anthoid11313313anthoid
antiar6317173antiar
antichlor1444873antichlor
antler64615553antler
anymore1256243anymore
anyon85615223an_yon
arbor74818113a_rbor
arch98628443arch__
arched125717323arched
archers124414573archers
archery15478063archery
arches114822043arches
archfoe1544723archfoe
archil11611573archil
archly1437353archly
archons12311583archons
arco68331543arc_o_
ardor64617863a_rdor
armor75118053a_rmor
ascot76522513asc_ot
ashore9414613a_shore
authors10311853authors
banco94019393banc_o_
bancos104713893banc_os
batcher144414853batcher
bencher144113483bencher
blancher15338633blancher
cachou13310623cachou
camphor1636133camphor
cancer104220923canc_er
cancha134411613canch_a
canchas143212403canchas
candor94516423can_dor
canephor1543873canephor
cantor85621523can_tor
catcher143115823catcher
char95132153__char
choir105313603__choir
chon96627793__chon
chop116024923__chop
chord115917263__chord
chore105126763__chore
chow125820993__chow
coanchors1645733coanchors
concho134414263concho_
conchos144313963conchos
cor59960943__c_or
dancer94817613danc_er
decor84717573dec_or
doctor938993doctor
echo96615953_echo_
echoer114011103_echoer
echos105216463_echos
enactor938033enactor
enamor838753enamor
enchoric1547103enchoric
encore8314773enc_ore
ephor10310013_ephor
eschar1136533eschar
etcher113912943etcher
factor11911453factor
fancier123412063fancier
functor1235203functor
gaucher1337233gaucher
gaucho1256223gaucho_
gauchos1345903gauchos
hatcher153314723hatcher
hector113312653hector
honcho14389383honcho_
honchos15369573honchos
ichors11310423_ichors
inch95420823inch__
inched124514483inched
inchers123912523inchers
inches114419673inches
inchworm1843103inchworm
incisor955323incisor
incog838253inc_og
incur72212253inc_ur
indoor738403indoor
inkhorn1444363inkhorn
inshore1038723inshore
isochor1244743isochor
janitor1436483janitor
lancer84319973lanc_er
languor895423languor
lanthorn1147193lanthorn
launcher1365563launcher
lecher113415853lecher
lector83514983lector
lictor83610853lictor
luncher123111413luncher
lyncher15366553lyncher
macho126120153macho_
machos135217493machos
machzor2344263machzor
manche133515103manch_e
manches143818623manches
manchet143317783manchet
manihot121112053manihot
manor78023933man__or
marcher143912973marcher
markhor1635463markhor
matcher143214283matcher
mucho125013443mucho_
mucor94011943muc_or
muncher143610373muncher
nachas114914193nachas
naches114622413naches
nohow1137293_nohow
nor38048823_n__or
ocher104516103_ocher
onshore10310013onshore
panchax2134983panchax
pandoor10358583pandoor
panther12611443panther
parachor1546653parachor
patcher143515143patcher
pincher143812713pincher
poncho133310123poncho_
ponchos143410703ponchos
puncher143311673puncher
ranch105019793ranch__
ranched133113603ranched
ranchero13277423ranchero
ranchers133311793ranchers
ranches123620113ranches
rancors9811373ranc_ors
rancour987133rancour
rector84019753rector
richer114015043richer
salchow1544323salchow
sandhog1275453sandhog
santoor737433santoor
schorl1179813_schorl
sector83415933sector
senhor93010813senhor
stancher13198813stancher
succor1036623succor
synchro1544543synchro
tandoor8278563tandoor
tocher114014913tocher
unanchors1442613unanchors
unchair1236163unchair
unchary1537263unchary
unchic1338643unchic
unchoke16248193unchoke
unclog956603unclog
unco66021403unc_o_
uncool8610113uncool
uncork1239043unc_ork
uncos74117033unc_os
uncoy104111413unc_oy
unmoor836313unmoor
unshod1067603unshod
unshorn1036943unshorn
vector113212063vector
victor113210673victor
watcher153113403watcher
wencher153811133wencher
wincher153410653wincher

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 Filter1786911127160.373479064.3
2DLD Change Limit1127162445.76619548.4
3Display Results2442440.0763210.5
 (SQL Overall)1786912446.21528751.6
 
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.