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

377 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
auteur610794(None) 
auteurs7137501auteurs
hauteur1033891hauteur
acuter84412862acute_r
after85719792afte_r
alter54828502alte_r
amateur933892amateur
apter76120202apte_r
aster55434892aste_r
auger64922472auge_r
augur64311212au_gur
aureus65314882aureus
author939762author
cuter74728232cute_r
hauteurs1133732hauteurs
luteum837782luteum
muter74525542mute_r
outer55633302oute_r
tauter64318022taute_r
abater85518123abate_r
abler75624313able_r
abuser85413683abuse_r
abutter957513abutter
acetum1038463acetum
acted88521733acte_d
actor71116083act_or
aculeus937513aculeus
acute74720363acute__
acutely1246123acutely
acutes83917723acute_s
acutest94410603acutest
adder75419593adde_r
adieu6417423adieu_
adieus739633adieus
adieux1444283adieux
aeneus61111143aeneus
aether94213673aether
afters94717073afters
ager55935843a_ge_r
agger76420893agge_r
aider65431133aide_r
aimer75926823aime_r
airer54927893aire_r
aiver85725163aive_r
alder65421913alde_r
altar55520643alt_ar
alterer72714003alterer
alters64924223alters
amateurs1043653amateurs
ambeer104511603ambeer
amber94523213ambe_r
ameer75618983a_meer
amour75014853a_mour
amuser84712623amuse_r
anear55420323a_near
anger66225873ange_r
antbear935063antbear
ante46538903ante__
anted66328243ante_d
anteed75616113anteed
antes56334323ante_s
anther93715063anther
antiar6317173antiar
antifur1047493antifur
antler64615553antler
antrum8611313antrum
aper66336233a_pe_r
appear10379343appear
aptest82917513aptest
arbour84211333arbour
ardour74110903ardour
arguer74510543arguer
armer76924443arme_r
armour84411853armour
arrear6310253arrear
artel56122743arte_l
artels66216233artels
artery9911453artery
artful968273artful
artier63419733artier
asker96418783aske_r
asper75520433aspe_r
astern64815813astern
asters65631603asters
astir55517093ast_ir
ate37059243a_te__
ates45047923a_te_s
attar56516693a_ttar
attend7258973attend
attent62818323attent
attest62618613attest
auburn836213au_burn
augend837633augend
augers73818703augers
augurs7399963au_gurs
augury10366663au_gury
aulder7511453aulder
aurar54420253au_rar
aurei54821863aure_i
aures55137093aure_s
aurous64119263aurous
aurum7614963au_rum
austere7312993austere
austerer838383austerer
auteurism1144613auteurism
auteurist946783auteurist
authors10311853authors
autism83815333autism
autist64324943autist
auto47432083aut__o
autobus996513autobus
autoed7712823autoed
autos56523323aut_os
autumn836013autumn
aver75931883a_ve_r
baiter84422553baite_r
banter84825333bante_r
barter85525373barte_r
baster85333593baste_r
batter84928873batte_r
biter75030033bite_r
bulgur9387533bulgur
bunter85020383bunte_r
buster84726493buste_r
bute66739673bute__
butene8312623butene
buteo75419893bute_o
buteos84913413buteos
butes714535873bute_s
butler84220033butler
butter84724233butter
butut75522913but_ut
buyer105013093buye_r
canter85230113cante_r
carter84932273carte_r
caster85232573caste_r
cater74840723cate_r
causer84117783cause_r
cautery12349593cautery
citer74827333cite_r
couter84930223coute_r
cuber95222533cube_r
curer75030753cure_r
curter85320083curte_r
cute66440453cute__
cutely115312803cutely
cutes79438323cute_s
cutest85820143cutest
cutesy114810733cutesy
cutey105819793cute_y
cuteys11569983cuteys
cutler84718033cutler
cutout8315923cutout
cutter84521003cutter
cutup9410093cut_up
dafter104813343dafte_r
danseur833663danseur
darter75320363darte_r
dater65332313date_r
dauber94112013daube_r
daunter83811753daunte_r
dauted84114933daute_d
deter65028043dete_r
detour778193detour
diseur738843diseur
doter65428623dote_r
douceur1043113douceur
duper85519003dupe_r
duster74919723duste_r
duteous838453duteous
easter65027983easte_r
eater54639843eate_r
enter54726383ente_r
ester54727713este_r
faitour1034883faitour
falter94519053falte_r
farceur12525273farceur
faster94625773faste_r
fatter94523213fatte_r
fauteuil1142023fauteuil
fluter95316863flute_r
fumer105918233fume_r
furfur1235553furfur
future939563fut_ure
gaiter73819503gaite_r
garter74420513garte_r
gaster75027353gaste_r
gater64533653gate_r
gauger84714853gauge_r
gaunter82910713gaunte_r
gluteus8386253gluteus
gutter73817713gutter
hafter124815883hafte_r
halter94420883halte_r
hater85034753hate_r
hatter94724873hatte_r
hauler95015123haule_r
haunter103111153haunte_r
haute89521613haute__
huger94914873huge_r
humour11116753humour
hunter94817773hunte_r
hurter93915853hurte_r
inter55028493inte_r
juster134617013juste_r
jute115327893jute__
jutes125125133jute_s
kiter95523213kite_r
kultur1034433kultur
laster64830633laste_r
later54843923late_r
latter65027893latte_r
lauder73815013laude_r
liter54736343lite_r
luger65322083luge_r
lurer54625313lure_r
luster64023673luste_r
lute46341013lute__
lutea54819073lute_a
luteal64411483luteal
luted64826143lute_d
lutein6311263lutein
luteous739273luteous
lutes55836663lute_s
masseur935703masseur
master84831343maste_r
mater74438863mate_r
matter84325343matte_r
mauger93813483mauge_r
mauler84416713maule_r
meteor84910073meteor
meter75130323mete_r
miter75734793mite_r
muggur10325593muggur
murmur1034853murmur
muser76024123muse_r
museum1037703museum
muster84724523muste_r
mute65136873mute__
muted85023383mute_d
mutely113811653mutely
mutes75033783mute_s
mutest84218053mutest
mutter84418883mutter
mutuel837823mutuel
natter64420743natte_r
neuter63713793neute_r
niter55028973nite_r
noter55025643note_r
nuder66416833nude_r
nutter63918053nutter
oater55433733oate_r
ofter84116873ofte_r
otter54423973otte_r
ouster64223733ouste_r
outburn936903outburn
outbuy1146943outbuy
outearn7310683outearn
outeat62824533outeat
outed65429063oute_d
outers64230173outers
outgun7349643outgun
outhear10910603outhear
outjut13610073outjut
outpour937423outpour
output8712853output
outrun63213303outrun
outturn737123outturn
outwar91011513outwar
outwear1097713outwear
oxter123414093oxte_r
palter84423263palte_r
paster85734373paste_r
pasteup1134983pasteup
pater74740723pate_r
patter84628263patte_r
pauper103511943paupe_r
pauser84415963pause_r
peter74427593pete_r
pluteus9326243pluteus
poseur8419403poseur
pouter83923983poute_r
puler74826623pule_r
punter84320023punte_r
purer75127903pure_r
putout8315113putout
putter83921443putter
queer143712813qu_eer
queue143711233qu_eue
queuer15357253qu_euer
quoter153510093quote_r
rafter94517583rafte_r
ranter63826823rante_r
raster64731443raste_r
rater54943283rate_r
ratter64326313ratte_r
retear63115483retear
router65025843route_r
ruder65320543rude_r
ruer46127563ru_e_r
ruler54923343rule_r
rumour8127383rumour
saboteur1042003saboteur
salter64325083salte_r
saluter73512453salute_r
santour737373santour
santur6311273sant_ur
saucer84314103sauce_r
sauger74316253sauge_r
saunter72913453saunte_r
saute55028083saute__
sauted74119603saute_d
sauteed8349613sauteed
sautes63924913saute_s
sautoir735183sautoir
sieur5911893_sieur
souter64225923soute_r
steer55423863_steer
stour54916743_stour
suber74924503sube_r
suer45334033su_e_r
suiter64121813suite_r
sulfur937913sulfur
super74924483supe_r
surer54833103sure_r
sutler63718393sutler
suture6313203sut_ure
tarter64023563tarte_r
taster64930573taste_r
tater54138613tate_r
tatter64024573tatte_r
taunter73111453taunte_r
tautaug883023tautaug
tauted75317113taute_d
tauten64311893taute_n
tautens7317843tautens
tautest72612443tautest
tear45242883__tear
titer55430613tite_r
toter55932133tote_r
tour45530383__tour
touter63821033toute_r
tuber75420683tube_r
tufter9319933tufte_r
tumour8137403tumour
tuner56022683tune_r
tuneup835203tuneup
tussur6357293tussur
tutee5423523tute_e
tutees6514553tutees
tutelar735373tutelar
tutor5712493tut_or
tutu48423173tut_u_
tutued7349413tutued
tutus55214813tut_us
tuyer85414293tuye_r
uptear896783uptear
user45023003_use_r
ute35335883_ute__
uteri51012983_uteri
uterus639203_uterus
utes45930883_ute_s
utter54218763_utter
vaster94521023vaste_r
vaulter10257713vaulte_r
vaunter10309603vaunte_r
voter85121053vote_r
voyeur1232863voyeur
wafter124114613wafte_r
waiter94321253waite_r
wanter94423053wante_r
waster95228943waste_r
water84733313wate_r
watter93221983watte_r
wuther124511613wuther
yatter94116213yatte_r
yauper11368543yaupe_r

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.376475242.0
2DLD Change Limit1127163775.72019705.6
3Display Results3773770.1103427.3
 (SQL Overall)1786913776.20628793.3
 
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.