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

228 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
laten5432834(None) 
eaten55323051eaten
laden65022191laden
late47560481late_
lated65240671lated
lateen64014861lateen
latens64620211latens
latent64124301latent
later54843921later
latex124717111latex
latten65018201latten
oaten55222401oaten
paten74827341paten
platen84518201platen
alate55340322alate_
alated75625142alated
alates64833962alates
alien56425582alien
alter54828502alter
amen66733152_amen
ate37059242_ate_
ates45047922_ates
bate66552422bate_
bated85935532bated
bates75846342bates
batmen104414302batmen
baton75822422baton
batten85217122batten
beaten84617062beaten
blate75933782blate_
cate66254602cate_
catena8312482catena
cater74840722cater
cates75951892cates
date56443322date_
dated75530992dated
dater65332312dater
dates65639152dates
daven94916472daven
dawen95413722dawen
eater54639842eater
elate55335882elate_
elated74725822elated
elater64724202elater
elates65032362elates
fasten95114892fasten
fate75444282fate_
fated95632132fated
fates85139232fates
fatten94314902fatten
flamen115215992flamen
flatten10429652flatten
flaxen16518572flaxen
gaen57329602ga_en
gate55746572gate_
gated75329772gated
gater64533652gater
gates65939512gates
gluten74210752gluten
haen76229452ha_en
hapten115312982hapten
hasten95718562hasten
hate78450172hate_
hated95734022hated
hater85034752hater
hates86742572hates
haven114718532haven
label75019382label
lace66848472lace_
laced87132642laced
lacer75833752lacer
laces76141762laces
lacey105820912lacey
lactean956472lactean
lade56345982lade_
laded74232612laded
ladens74516232ladens
lader65633722lader
lades65141272lades
lagan66520342lagan
lagend838742lagend
lager65132862lager
lain46146282la_in
lake85741602lake_
laked105731122laked
laker95432872laker
lakes95737652lakes
lame66849292lame_
lamed85235292lamed
lament85024942lament
lamer75233702lamer
lames75445542lames
lane45153332lane_
lanes54946792lanes
lantern7310012lantern
lapel73716682lapel
lapin75222922lapin
laree56036292laree
lares54852632lares
lase46148512lase_
lased65132342lased
laser54633322laser
lases54944762lases
lasted74323602lasted
laster64830632laster
lat37593402lat__
latch104620462latch
lateens74210552lateens
lately93413842lately
latency1236032latency
latened8711922latened
latents75214312latents
latest63822702latest
lath76640382lat_h
lathe85626712lathe
lathed104718452lathed
lather95124352lather
lathes95127492lathes
lathi85417202lathi
laths86022402laths
lathy115215062lathy
lati46438272lat_i
latina65621142latina
latino64120472latino
latke94817092latke
latkes104715872latkes
lats45962702lat_s
latte55426302latte
lattens75014672lattens
latter65027892latter
lattes65324202lattes
lattin64316222lattin
latu47934182lat_u
lauan55216792lauan
lave75642142lave_
laved95028592laved
laver85031792laver
laves86039152laves
lawed96028322lawed
lawmen11308592lawmen
lawn75925632la_wn
laxer125420332laxer
laxes125430092laxes
layed95127382layed
layer84626472layer
layin84720332layin
laymen113010842laymen
laze136235052laze_
lazed154925842lazed
lazes145129572lazes
leaden74515222leaden
leaven95013072leaven
leben7314852leben
lenten6312882lenten
lien45339802l_ien
liken911818842liken
limen75426032limen
linen55728722linen
listen64816812listen
lite47054542lite_
liter54736342liter
litten64014872litten
liven85021732liven
loden66621142loden
lumen75220902lumen
lute46341012lute_
lutea54819072lutea
luted64826142luted
lutein6311262lutein
lutes55836662lutes
marten84518262marten
mate65154222mate_
mated85537782mated
mater74438862mater
mates75251362mates
matey107022662matey
matin75132852matin
maven104816892maven
nates55238332nates
neaten64214542neaten
oaken95814382oaken
oater55433732oater
often84611412often
pate65350462pate_
pated85237842pated
patens84820862patens
patent84524922patent
pater74740722pater
pates76047892pates
patin76832852patin
patten84418192patten
platan83913692platan
plate74635112plate_
plated95225772plated
platens94213982platens
plater84427692plater
plates85432242plates
ramen75625192ramen
ratan53722662ratan
rate45458762rate_
rated65441382rated
ratel54224882ratel
rater54943282rater
rates55352012rates
ratten64217382ratten
raven84723442raven
sate45556102sate_
sated66238532sated
sateen63815012sateen
satem76021462satem
sates54949322sates
satin55935222satin
slate55438282slate_
slated75028312slated
slater64429182slater
slates64934062slates
slatey95417062slatey
taken94819142taken
tate44748602tate_
tater54138612tater
tates55444982tates
tauten64311892tauten
ten35856112__ten
waken124818472waken
water84733312water
waxen154911812waxen
yamen104115182yamen
zazen1337282zazen

Search took 2 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.300595636.7
2DLD Change Limit538002281.42037887.3
3Display Results2282280.0633619.0
 (SQL Overall)1786912281.783100219.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.