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 “paten” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

211 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
paten7482734(None) 
eaten55323051eaten
laten54328341laten
oaten55222401oaten
pate65350461pate_
pated85237841pated
patens84820861patens
patent84524921patent
pater74740721pater
pates76047891pates
patin76832851patin
patten84418191patten
platen84518201platen
amen66733152_amen
apter76120202apter
ate37059242_ate_
ates45047922_ates
bate66552422bate_
bated85935532bated
bates75846342bates
batmen104414302batmen
baton75822422baton
batten85217122batten
beaten84617062beaten
cate66254602cate_
catena8312482catena
cater74840722cater
cates75951892cates
date56443322date_
dated75530992dated
dater65332312dater
dates65639152dates
daven94916472daven
dawen95413722dawen
eater54639842eater
fasten95114892fasten
fate75444282fate_
fated95632132fated
fates85139232fates
fatten94314902fatten
gaen57329602ga_en
gate55746572gate_
gated75329772gated
gater64533652gater
gates65939512gates
haen76229452ha_en
hapten115312982hapten
hasten95718562hasten
hate78450172hate_
hated95734022hated
hater85034752hater
hates86742572hates
haven114718532haven
laden65022192laden
late47560482late_
lated65240672lated
lateen64014862lateen
latens64620212latens
latent64124302latent
later54843922later
latex124717112latex
latten65018202latten
marten84518262marten
mate65154222mate_
mated85537782mated
mater74438862mater
mates75251362mates
matey107022662matey
matin75132852matin
maven104816892maven
nates55238332nates
neaten64214542neaten
oaken95814382oaken
oater55433732oater
often84611412often
pace86345772pace_
paced106931682paced
pacer96131612pacer
paces96741112paces
pacey126720282pacey
paean77222722paean
paeon74819492paeon
pagan86121162pagan
page76036102page_
paged95926782paged
pager84728202pager
pages85235072pages
pain65647242pa_in
pale66055012pale_
palea75028662palea
paled85538722paled
paler75436932paler
pales75753802pales
palet74650802palet
palter84423262palter
pan58466452pa__n
pane64950292pane_
paned85437182paned
panel76023622panel
panes76148692panes
pangen94115922pangen
panne76623652panne
panted95024822panted
paper95128662paper
pare66760842pare_
pared86946762pared
parent83230422parent
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
partan83820562partan
parted94228682parted
parton84720992parton
pase65346862pase_
paseo77022512paseo
pases75346502pases
paste74932952paste_
pasted94426902pasted
pastel85918712pastel
paster85734372paster
pastern94415062pastern
pastes85233912pastes
pat58089462pat__
patch125221222patch
patency1466312patency
patents94815202patents
paters84935832paters
path99134912pat_h
paths105521382paths
patient9617072patient
patina86022192patina
patine85328122patine
patins87528782patins
patio74426352patio
patly105020582patly
patron84018042patron
pats66460852pat_s
patsy105717202patsy
patted94724682patted
pattee84323382pattee
pattens95414922pattens
patter84628262patter
pattern93712052pattern
patty104723612patty
paty95234562pat_y
patzer173111642patzer
pavan106518472pavan
pave96133892pave_
paved115525262paved
paver104225832paver
paves104833922paves
pavin105623202pavin
pawed115725612pawed
pawer104422972pawer
pawn94625302pa_wn
paxes144928422paxes
payed115925932payed
payee105524722payee
payer105125722payer
peahen113410132peahen
peasen84815962peasen
pecten102711102pecten
peen65938082p_een
pen56558842p__en
peter74427592peter
pitmen102510792pitmen
piton76121582piton
platan83913692platan
plate74635112plate_
plated95225772plated
platens94213982platens
plater84427692plater
plates85432242plates
poteen83514262poteen
potent84223352potent
potmen102713092potmen
prate75135982prate_
prated94924922prated
prater84825352prater
prates84633162prates
preen75925052preen
puton73617912puton
ramen75625192ramen
ratan53722662ratan
rate45458762rate_
rated65441382rated
ratel54224882ratel
rater54943282rater
rates55352012rates
ratten64217382ratten
raven84723442raven
sate45556102sate_
sated66238532sated
sateen63815012sateen
satem76021462satem
sates54949322sates
satin55935222satin
spate74731582spate_
spates85028172spates
taken94819142taken
tate44748602tate_
tater54138612tater
tates55444982tates
tauten64311892tauten
ten35856112__ten
waken124818472waken
water84733312water
waxen154911812waxen
yamen104115182yamen
zazen1337282zazen

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538002111.64032804.9
3Display Results2112110.0464587.0
 (SQL Overall)1786912111.99989390.2
 
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.