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

261 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
authors1031185(None) 
author939761author_
abhors11410622a_bhors
actors81016772act_ors
aethers103614942aethers
althorn1047762althorn
althorns1146732althorns
anchors123912952anchors
anthers103715202anthers
auteurs7137502auteurs
authored1238262authored
authoress1245172authoress
authorise1248022authorise
autos56523322aut_o_s
coauthors1444312coauthors
futhorc1544312futhorc
futhorcs1643542futhorcs
futhork1745102futhork
futhorks1844602futhorks
tutors6912332tut_ors
wuthers133711522wuthers
abators94413093abators
abettors1056133abettors
abhor10411063a_bhor_
abmhos1334973abmho_s
abutters1056993abutters
actions94218513actions
actor71116083act_or_
aether94213673aether_
afters94717073aft_ers
ahorse9311513a__horse
algors7312553a_lgors
alphorn1246393alphorn
alphorns1345223alphorns
altars64518153alt_ars
alters64924223alt_ers
altheas1038233altheas
altho86312603altho__
altos55822953alt_o_s
amphora1446923amphora
amphoras1547083amphoras
anaphors1346633anaphors
anchor113911973anchor_
anchos114214893ancho_s
anethols1145843anethols
anthems12309423anthems
anther93715063anther_
anthoid11313313anthoid
antiars7314623antiars
antlers74014743antlers
antrorse846933antrorse
aphthous1694873aphthous
arbors84717883a_rbors
archers124414573archers
archons12311583archons
ardors74416873a_rdors
armors85017813a_rmors
artwork1447093artwork
artworks1546523artworks
ashore9414613a_shore
asters65631603ast_ers
asthmas12117363asthmas
athirst1037873a_thirst
atoms76817563a_t_oms
attars64515313a_ttars
attorn6310793a_ttorn
attorns738443a_ttorns
auctions104012143auctions
audios72312283audio_s
auditors947613auditors
augers73818703au_gers
aughts104710243augh_ts
augurs7399963au_gurs
aunthood1254723aunthood
aunthoods1344333aunthoods
aurora6411763au_rora
auroras7311703au_roras
aurous64119263au_rous
ausform1245233ausform
ausforms1343933ausforms
auteur6107943auteur_
authorial1247083authorial
authoring1348583authoring
authorised1444513authorised
authorises1347583authorises
authority1545693authority
authorize2146903authorize
authorizes2247003authorizes
authorship18114633authorship
autisms94311553autisms
autists73814853autists
auto47432083aut_o__
autobus996513autobus
autoed7712823aut_oed
autoharp1343943autoharp
autoharps1443713autoharps
autopsy1244373aut_opsy
autumns943763autumns
bathers124720363bathers
bathos116215633batho_s
bethorn1238643bethorn
bethorns1337323bethorns
bettors93312473bettors
bothers124317753bothers
buhrs104811243bu_h_rs
bushers124018803bushers
butchers153710183butchers
buteos84913413buteo_s
butlers94518053butlers
butters94521723butters
buttons9310333buttons
camphors1737053camphors
cantors94620753cant_ors
captors113914983capt_ors
carthorse1446293carthorse
castors94919443cast_ors
cautions103313183cautions
cautious103110233cautious
cithers124315773cithers
coauthor1343463coauthor_
cursors93910023cursors
cutlers94217003cutlers
cutters94218963cutters
cutwork16176823cutwork
cutworks17166003cutworks
cutworm14186353cutworm
cutworms15184983cutworms
dithers114016153dithers
druthers1275793druthers
duteous838453duteous
ephors11311403_ephors
ethers94518413_ethers
ethos85514193_etho_s
factors12912133fact_ors
fathers133916503fathers
fathoms1537523fathoms
fetors91014473fet_ors
furors9310953fu_rors
furthers1436493furthers
futharc1563713futharc
futharcs1653153futharcs
futhark1744233futhark
futharks1843783futharks
futons93911513fut_ons
gathers114315073gathers
gators74115843gat_ors
gauchos1345903gaucho_s
gushers113512513gushers
gutters83715513gutters
hautbois1343103hautbois
hautboys1642773hautboys
hauteurs1133733hauteurs
hawthorn1743553hawthorn
hawthorns1842823hawthorns
humors11129633hu_mors
ichors11310423_ichors
juniors1475783juniors
jurors1338283ju_rors
lanthorn1147193lanthorn
lanthorns1246013lanthorns
lathers104321883lathers
laughers1235923laughers
lithops12307253lithops
lithos94212553litho_s
luteous739273luteous
luthern1037653luthern
lutherns1136293lutherns
luthiers1135163luthiers
markhors1745393markhors
meteors94610013meteors
methods1338883methods
mithers123516733mithers
mothers123717623mothers
motors84616603mot_ors
mouthers133811303mouthers
mucors104410853mu_cors
murthers1336543murthers
mushers124016443mushers
mutons84314363mut_ons
mutters94117143mutters
muttons949283muttons
mythos14398463mytho_s
nonauthors1352523nonauthors
nuthouse1145833nuthouse
nutters74215433nutters
others93918003_others
outdoers937513outdoers
outdoes8313123outdoes
outdoors936433outdoors
outers64230173out_ers
outgoes8312643outgoes
outhears11810393outhears
outhits102213503outhits
outhomers1446063outhomers
outhouse11310883outhouse
outhowl1337203outhowl
outhowls1445723outhowls
outhumors1442593outhumors
outport9714123outport
outports1048273outports
outpours1036683outpours
outroars838923outroars
outrows10311403outrows
outsoars838853outsoars
outwars10912793outwars
outwore101912693outwore
outwork141710353outwork
outworks15148973outworks
outworn101610753outworn
panthers13510783panthers
pastors94119003past_ors
pathos115516693patho_s
pothers123818623pothers
pothos114214693potho_s
pushers123814503pushers
putlogs1065083putlogs
putons83515153put_ons
putters94219193putters
pythons1537363pythons
quahogs2043163quahogs
quittors17155413quittors
quohogs2042023quohogs
raptors94213353rapt_ors
rotors64917953rot_ors
rumors81110403ru_mors
rushers103816103rushers
ruths85714643ruth__s
santoors837633santoors
sartors7314973sart_ors
sautoirs834923sautoirs
senhors103512133senhors
southers114214453southers
stupors935883stupors
succors1137413succors
sudors7311103su_dors
suitors73012493suitors
sutlers73116973sutlers
tautogs875413taut_ogs
tethers103815313tethers
thorn85318703__thorn
thorns95314103__thorns
thoro86217873__thoro
thorp104414263__thorp
thorps113610893__thorps
thous86017263__thous
tithers104216733tithers
tors46157383__t_ors
tumors8810613tu_mors
turgors836833turgors
tussors7388773tussors
tutor5712493tut_or_
unhorse1038583_unhorse
ushers94415533_ushers
utters63817123_utters
warthogs1544823warthogs
watthours1542813watthours
wethers135214693wethers
withers134417753withers
wuther124511613wuther_
xanthous1846643xanthous
zithers193911973zithers

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.393454684.5
2DLD Change Limit1340272615.96622465.1
3Display Results2612610.1102372.7
 (SQL Overall)1786912616.46927622.7
 
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.