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

264 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
author93976(None) 
authors10311831authors
abhor10411062a_bhor
actor71116072act_or
aether94213672aether
altho86312602altho_
althorn1047762althorn
anchor113911972anchor
anther93715062anther
auteur6107942auteur
authored1238262authored
auto47432082aut_o_
autos56523322aut_os
coauthor1343442coauthor
futhorc1544312futhorc
futhork1745102futhork
tutor5712492tut_or
wuther124511612wuther
abator84512713abator
abettor956193abettor
abhors11410623a_bhors
abmho1236793abmho_
abmhos1334973abmhos
abutter957513abutter
achoo10315083a_choo
action84719683action
actors81016753act_ors
acuter84412863acut_er
aethers103614943aethers
after85719793aft_er
ahchoo1445713ahchoo
ahoy101919183a__hoy
algor6513053a_lgor
alphorn1246393alphorn
altar55520643alt_ar
alter54828503alt_er
althea938193althea
althorns1146723althorns
alto47831263alt_o_
altos55822953alt_os
amphora1446923amphora
anaphor1245653anaphor
ancho104515303ancho_
anchors123912953anchors
anchos114214893anchos
anethol1045383anethol
another10289153another
anthem113410343anthem
anthers103715203anthers
anthoid11313303anthoid
antiar6317173antiar
antler64615553antler
anyhow1544103anyhow
apter76120203apt_er
arbor74818113a_rbor
archer115016243archer
archon11311753archon
ardor64617863a_rdor
armor75118053a_rmor
artier63419733artier
artwork1447083artwork
ashore9414613a_shore
aster55434893ast_er
asthma11126563asthma
astir55517093ast_ir
atom67824523a_t_om
atop66124753a_t_op
attar56516693a_ttar
attorn6310793a_ttorn
auction93412933auction
audio62917103audio_
audios72312283audios
auditor837313auditor
auger64922473au_ger
aught95120703augh_t
aughts104710243aughts
augur64311213au_gur
aulder7511453aulder
aunthood1254723aunthood
aurar54420253au_rar
aurora6411763au_rora
ausform1245233ausform
auteurs7137503auteurs
authoress1245173authoress
authorial1247083authorial
authoring1348583authoring
authorise1248023authorise
authority1545693authority
authorize2146903authorize
autism83815333autism
autist64324943autist
autoed7712823autoed
autoharp1343943autoharp
autumn836013autumn
bather115322513bather
bathos116215633bathos
bethorn1238643bethorn
bettor83612223bettor
bother115218063bother
buhr95315383bu_h_r
busher114922203busher
butcher143411163butcher
buteo75419893buteo_
buteos84913413buteos
butler84220033butler
butter84724233butter
button8310273button
camphor1636133camphor
cantor85621523cant_or
captor104914603capt_or
castor84418533cast_or
caution93013513caution
cither114616683cither
coauthors1444293coauthors
couther123914623couther
cursor84110293cursor
cuter74728223cut_er
cutler84718033cutler
cutter84520993cutter
cutwork16176813cutwork
cutworm14186343cutworm
dither104417683dither
either94517423either
ephor10310013_ephor
ether84518773_ether
ethos85514193_ethos
factor11911453fact_or
farther1348343farther
father125116713father
fathom1437473fathom
fetor81214533fet_or
furor8312393fu_ror
further1337003further
futharc1563713futharc
futhark1744233futhark
futhorcs1643533futhorcs
futhorks1844603futhorks
futon83113773fut_on
gather104115853gather
gator64416033gat_or
gaucher1337233gaucher
gaucho1256223gaucho_
gauchos1345893gauchos
gusher104115773gusher
gutter73817703gutter
hautboy1553423hautboy
hauteur1033893hauteur
hawthorn1743553hawthorn
hither124417253hither
humor101110513hu_mor
ichor1039473_ichor
ither84617603_ither
junior1386143junior
juror1239563ju_ror
lanthorn1147193lanthorn
lather95124353lather
laugher1136603laugher
lither94520953lither
litho86513783litho_
lithos94212553lithos
lusher93818763lusher
luthern1037653luthern
luthier1038233luthier
markhor1635463markhor
meteor84910073meteor
method1239023method
mither114218563mither
mother113718643mother
motor75317293mot_or
mouther123812813mouther
mucho125013443mucho_
mucor94011943mu_cor
murther1237953murther
musher113820573musher
muter74525543mut_er
muton73817003mut_on
mutter84418883mutter
mutton8510453mutton
mythoi14417123mythoi
mythos14398463mythos
nether94014163nether
nonauthor1252363nonauthor
nother93815963nother
nutter63918053nutter
ortho8312293ortho_
other84219103_other
outbox1537453outbox
outdo6312703outdo_
outdoer849263outdoer
outdoor836703outdoor
outer55633303out_er
outfox1636133outfox
outgo6312093outgo_
outhear10910603outhear
outhit92818463outhit
outhomer1348133outhomer
outhowl1337203outhowl
outhumor1342743outhumor
outport9714123outport
outpour937413outpour
outroar739513outroar
outrow9311173outrow
outshot10312103outshot
outsoar739493outsoar
outwar91011513outwar
outwore101912693outwore
outwork141710353outwork
outworn101610753outworn
panther12611443panther
pastor84817483past_or
pathos115516693pathos
pother113818853pother
pothos114214693pothos
pusher114318283pusher
putlog965553putlog
puton73617913put_on
putter83921443putter
putto75617663putto_
python1447143python
quahog1944103quahog
quittor16285603quittor
quohog1942503quohog
raptor83912823rapt_or
rather94319733rather
rotor55519733rot_or
rumor71011323ru_mor
rusher94019653rusher
ruth76825993ruth__
ruths85714643ruth_s
santoor737433santoor
sartor6313873sart_or
sautoir735163sautoir
senhor93010803senhor
souther104116303souther
stupor836013stupor
succor1036623succor
sudor6312623su_dor
suitor63311053suitor
sutler63718393sutler
tauter64318023taut_er
tautog765713taut_og
tether93716103tether
thir76420543__thir
tho67433963__tho_
thorn85318703__thorn
thoro86217873__thoro
thorp104414263__thorp
thou76722213__thou
thro77726423__thro
tither94920283tither
tor39261683__t_or
tother94117143tother
tumor71110693tu_mor
turgor736863turgor
tussor6378233tussor
tutors6912323tut_ors
usher84517763_usher
utter54218763_utter
warthog1444533warthog
watthour1442883watthour
wether123315393wether
wither124321353wither
wuthers133711523wuthers
zither183813083zither

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.1401276364.3
2DLD Change Limit1127162646.26617988.5
3Display Results2642640.0932838.7
 (SQL Overall)1786912646.49927495.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.