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

368 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
maturer93898(None) 
manurer938581manurer
mature8313471mature_
matured10310041matured
maturers1037381maturers
matures9314311matures
capturer1246092capturer
caterer92815942caterer
manure8313652manure_
manured1039472manured
manurers1037592manurers
manures9313352manures
marrer83716672ma_rrer
matcher143214282matcher
mater74438862mat__er
matier84321522mat_ier
matres84522232mat_res
matter84325342mat_ter
maturely1344902maturely
maturest1039702maturest
mauger93813482ma_uger
mauler84416712ma_uler
measurer1035952measurer
miterer92511332miterer
nature6311262nature_
natured838962natured
natures7311962natures
pasturer1037522pasturer
waterer103314072waterer
abjurer1634753abjurer
abuser85413683_abuser
acuter84412863_acuter
adjurer1534823adjurer
adorer74713453_adorer
airer54927893_a_irer
allurer7348433allurer
alterer72714003alterer
amuser84712623_amuser
armature10106973armature_
armatured1264623armatured
armatures1166983armatures
assurer767793assurer
atoner64817193_atoner
auger64922473_a_uger
augurer8136343augurer
aurar54420253_a_urar
aurei54821863_a_urei
aures55137093_a_ures
azure14911483_azure_
azures15510183_azures
banterer102811773banterer
barer74535803ba__rer
barterer102711633barterer
batcher144414853batcher
bather115322513bat_her
batter84928873bat_ter
batterer102713213batterer
battier93515713battier
battler94113383battler
caperer113013403caperer
capture1138913capture_
captured1336573captured
capturers1344633capturers
captures1239443captures
carer74942333ca__rer
catbrier1236173catbrier
catcher143115823catcher
cater74840723cat__er
catered103117773catered
caterers102814403caterers
cattier93317073cattier
causer84117783ca_user
curer75030753__curer
darer65230793da__rer
dater65332313dat__er
datura738033datur_a
daturas838783daturas
daturic1047033daturic
dauber94112013da_uber
demurer1037873demurer
dourer74215273_dourer
eagerer8248823eagerer
eater54639843eat__er
endurer83210363endurer
ensurer73011903ensurer
enterer72015633enterer
facture12108933facture_
factures13129033factures
fairer95212063fa_irer
falterer11239863falterer
farer86733143fa__rer
father125116713fat_her
fatter94523213fat_ter
fattier103513463fattier
favorer1355883favorer
favourer1443823favourer
feature1039853feature_
featured1237683featured
features11310333features
figurer11215863figurer
fracturer14134643fracturer
future939563future_
futures10310263futures
gater64533653gat__er
gather104115863gat_her
gatherer12147913gatherer
gauger84714853ga_uger
gesturer935983gesturer
hatcher153314723hatcher
hater85034753hat__er
hatred104814333hat_red
hatter94724873hat_ter
hauler95015123ha_uler
immature1244443immature_
immatures1344333immatures
impurer1136483impurer
injurer14318473injurer
insurer73312803insurer
laborer9249513laborer
labourer1045763labourer
later54843923lat__er
lather95124363lat_her
latherer111310453latherer
lathier10310833lathier
latter65027893lat_ter
lauder73815013la_uder
laurel649033la_urel
lecturer10136033lecturer
lurer54625313__lurer
macaber1336163macaber
macer912126943ma__cer
machree1438513machree
macular113011943macular
macule104115273macule_
maculed123510053maculed
macules114015133macules
madder103515593ma_dder
madre85720173ma_dre_
madres93718183ma_dres
maduro936983madur_o
maduros1036303maduros
maguey1236833magu_ey
maigre9309163maigre_
mailer84724183ma_iler
maimer104514593ma_imer
majored1735853majored
maker114127813ma__ker
malgre9299303malgre_
malmier113611953malmier
maltier93015483maltier
maltster1035303maltster
mammer94218863ma_mmer
mamzer19459833ma_mzer
manager103413583manager
mandrel1038683mandrel
maneuver1343333maneuver
manger94325003ma_nger
mangier104114063mangier
mangler103215643mangler
manlier92414023manlier
manner84020513ma_nner
mapper124516093ma_pper
marauder1144553marauder
marbler113511673marbler
marcher143912973marcher
mare64759333ma__re_
mares76457633ma__res
mariner93315993mariner
marker124420393ma_rker
marlier92614773marlier
marred95421043ma_rred
marrers93414313ma_rrers
marrier93817523marrier
martyred1434283martyred
maser75029973ma__ser
masher114123203ma_sher
masker124416103ma_sker
masquer18266463masquer
massier93615223massier
master84831343ma_ster
mastered112614003mastered
matador1066253matador
matched153513963matched
matchers153012433matchers
matches143219783matches
mate65154223mat__e_
mated85537783mat__ed
materiel10311253materiel
maters85032393mater_s
mates75251363mat__es
matey107022663mat__ey
matinee92415613matinee
matrix1539853mat_rix
matron83918313mat_ron
matte75626843mat_te_
matted94521413mat_ted
mattered112412903mattered
matters94421753matters
mattery123810713mattery
mattes85624533mat_tes
mattress1036533mattress
maturate10312623maturate
maturated1249163maturated
maturates11311763maturates
maturing1139963maturing
maturity1367443maturity
maugre9308973maugre_
mauled94817823ma_uled
maulers94213303ma_ulers
maumet103518883ma_umet
maunder10328683maunder
mauve104013273ma_uve_
mauves113811553ma_uves
mazer165722423ma__zer
mazier175013063ma_zier
mazurka2272873mazurka
measure939033measure_
measured1136463measured
measurers1144883measurers
measures1038913measures
meatier93214613meat_ier
meatuses1038203meatuses
merer75126233m__erer
metamer1139613metamer
meter75130323met__er
metered103514013metered
metier83517693met_ier
metre74821303met_re_
metred95315143met_red
metres85121563met_res
minuter93510413minuter
misuser93210443misuser
miter75734793mit__er
mitered103213233mitered
miterers10219683miterers
mither114218563mit_her
mitier83620673mit_ier
mitre75522423mit_re_
mitred94414343mit_red
mitres83922073mit_res
mixture1635413mixture_
mixtures1735753mixtures
mother113718643mot_her
mothier121910213mothier
motlier92010583motlier
motored1039933motored
mottler94410343mottler
mourner938093m_ourner
mouser85822443m_ouser
mouther123812813mouther
multure939183multure_
multures1039333multures
murder93613783m__urder
mure65941333m__ure_
mured85726703m__ured
mures75937223m__ures
murex145517173m__urex
murker123715243m__urker
murmurer1242873murmurer
murr65225133m__ur_r
murre74821073m__urre
muser76024123m__user
muter74525543m__uter
mutter84418883mut_ter
mutterer10218913mutterer
mutuel837823mutu_el
mutular936643mutular
mutule8311423mutule_
mutules9311843mutules
mythier15125183mythier
natter64420743nat_ter
nattier73614623nattier
natural739513natural
nurturer844473nurturer
oater55433733oat__er
obtuser9134453obtuser
palterer102411283palterer
paperer113111903paperer
parer75839903pa__rer
parure8312523parure_
parures9512693parures
pasture9311463pasture_
pastured1138233pastured
pasturers1136393pasturers
pastures10311963pastures
patcher143515143patcher
pater74740723pat__er
patter84628263pat_ter
patterer103112173patterer
patzer173111643pat_zer
pauper103511943pa_uper
pauser84415963pa_user
posturer1038923posturer
pourer84516043_pourer
purer75127903__purer
rapture937393rapture_
raptured1155473raptured
raptures1037583raptures
rarer54731703ra__rer
rasure6311423rasure_
rasures7312013rasures
rater54943283rat__er
rather94319743rat_her
ratter64326313rat_ter
rattier74015593rattier
rattler74012743rattler
retirer74715013retirer
returner8397983returner
roturier836033roturier
saluter73512453saluter
satire63218003satire_
satires72617573satires
saturater947903saturater
saucer84314103sa_ucer
sauger74316253sa_uger
saurel6511993sa_urel
savorer1057883savorer
savourer1134473savourer
scourer93910433scourer
securer958253securer
smatter93613333smat_ter
smatterer11185813smatterer
sourer63620213_sourer
starer64027363_starer
stature74410683stature_
statures83711113statures
storer64721673_storer
surer54833103__surer
suture6313203suture_
sutured8310373sutured
sutures7314223sutures
taborer9269293taborer
tabourer1035743tabourer
taperer92511793taperer
tater54138613tat__er
tatter64024573tat_ter
tattier74216243tattier
tattler73112213tattler
tauter64318023ta_uter
torturer835493torturer
tourer64115073_tourer
truer54916643__truer
tuber75420683__tuber
tuner56022683__tuner
turner63914613__turner
tuyer85414293__tuyer
unmatured1245703unmatured
untruer737113untruer
usurer638103_usurer
utterer71910463utterer
vaguer10448443vagu_er
valuer93911443valu_er
vaporer1236983vaporer
vapourer1344263vapourer
venturer1137243venturer
wafture1334853wafture_
waftures1434853waftures
wagerer11328493wagerer
watcher153113403watcher
water84733313wat__er
watered113014953watered
waterers112312783waterers
waterier11312083waterier
watter93221983wat_ter
waverer13319523waverer
yarer84321573ya__rer
yatter94116213yat_ter
yauper11368543ya_uper

Search took 8 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.390458182.1
2DLD Change Limit1340273686.70319995.1
3Display Results3683680.1262920.6
 (SQL Overall)1786913687.21924752.9
 
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.