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

141 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
oaten5522240(None) 
eaten55323051eaten
laten54328341laten
oaken95814381oaken
oater55433731oater
often84611411often
paten74827341paten
amen66733152_amen
ate37059242_ate_
ates45047922_ates
bate66552422bate_
bated85935532bated
bates75846342bates
batmen104414302batmen
baton75822422baton
batten85217122batten
beaten84617062beaten
boated94221972boated
boatel84314092boatel
boater84622092boater
boatmen1146912boatmen
cate66254602cate_
catena8312482catena
cater74840722cater
cates75951892cates
coated94927042coated
coatee84327222coatee
coater84329572coater
date56443322date_
dated75530992dated
dater65332312dater
dates65639152dates
daven94916472daven
dawen95413722dawen
doated84118182doated
eater54639842eater
fasten95114892fasten
fate75444282fate_
fated95632132fated
fates85139232fates
fatten94314902fatten
gaen57329602ga_en
gate55746572gate_
gated75329772gated
gater64533652gater
gates65939512gates
goatee73219532goatee
gotten73410112gotten
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
moated94819002moated
molten83311812molten
nates55238332nates
neaten64214542neaten
oared65030652oared
oases55330982oases
oat39888262oat__
oaters65029792oaters
oath76132152oat_h
oaths86117312oaths
oats46554212oat_s
oaves84925612oaves
octan71313482octan
octet7324062octet
ofter84116872ofter
olden65114852olden
omen66828182o_men
open66427002o_pen
opted84914272opted
orate55133302orate_
orated74221502orated
orates64328612orates
otter54423972otter
outed65429062outed
outer55633302outer
ovate84214392ovate_
oven76624142o_ven
owsen84210192owsen
oxen116218592o_xen
oxter123414092oxter
pate65350462pate_
pated85237842pated
patens84820862patens
patent84524922patent
pater74740722pater
pates76047892pates
patin76832852patin
patten84418192patten
platen84518202platen
ramen75625192ramen
ratan53722662ratan
rate45458762rate_
rated65441382rated
ratel54224882ratel
rater54943282rater
rates55352012rates
ratten64217382ratten
raven84723442raven
rotten64115432rotten
sate45556102sate_
sated66238532sated
sateen63815012sateen
satem76021462satem
sates54949322sates
satin55935222satin
soften9429492soften
taken94819142taken
tate44748602tate_
tater54138612tater
tates55444982tates
tauten64311892tauten
ten35856112__ten
torten65314352torten
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 Limit538001412.04626295.2
3Display Results1411410.0463065.2
 (SQL Overall)1786911412.40574299.8
 
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.