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

163 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
datos6522278(None) 
dados75522431dados
dagos76419441dagos
dates65639151dates
dato56129941dato_
dattos74311901dattos
jatos125116821jatos
ratos55528761ratos
abos67734412_abos
adios65822862adios
ados57633512_ados
altos55822952altos
apos65433822_apos
ates45047922_ates
atom67824522_atom
atoms76817562_atoms
atop66124752_atop
autos56523322autos
avos77227012_avos
bates75846342bates
bathos116215632bathos
baths105922922baths
baton75822422baton
batons85519422batons
bats66962332bat_s
batts76727562batts
calos74431902calos
camos95927612camos
cantos84826972cantos
capos94826072capos
cates75951892cates
cats66356342cat_s
dabs77139402da_bs
daces85030682daces
dadas75819862dadas
dado67126332dado_
dadoes85616532dadoes
dads67442772da_ds
daffs125116422daffs
dago65725092dago_
dagoes85714602dagoes
dags66642602da_gs
dahls95012282dahls
dahs88231812da_hs
dais57040702da_is
daks97130602da_ks
dales66439742dales
dals57145122da_ls
dalton7311272dalton
daltons8310402daltons
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372da_ms
dangs75623202dangs
danios7314602danios
dans56748152da_ns
daps77239162da_ps
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
data56026652dat_a
date56443322dat_e
dated75530992dated
dater65332312dater
daters74827372daters
datto65416422datto
datum8310632datum
datums936352datums
daubs85014562daubs
dauts67822242dauts
dawks135213492dawks
dawns95916592dawns
daws86638242da_ws
dawts97216122dawts
days87637132da_ys
dazes155024142dazes
deaths105914442deaths
decos85522122decos
demos86022992demos
detox13310952detox
diatom939452diatom
diatoms1039072diatoms
didos76820812didos
dinos65428062dinos
ditas65923672ditas
dites66339152dites
dits56450522dit_s
dittos74111972dittos
doats65224882doat_s
dodos75819392dodos
dojos135111792dojos
dos48062312d__os
dotes65836692dotes
dots55647662dot_s
drats66628372drat_s
duos56728132d_uos
duros65422692duros
eats47054872eat_s
fados95620732fados
fanos85926502fanos
faros85532022faros
fates85139232fates
fats76252502fat_s
fatso85113492fatso
fatsos9389422fatsos
gates65939512gates
gator64416032gator
gators74115832gators
gats56753442gat_s
halos85230252halos
hates86742572hates
hats76858252hat_s
jato115822682jato_
katas95922092katas
kats85944332kat_s
kayos127714702kayos
kotos95717702kotos
laths86022402laths
lats45962702lat_s
lotos54724632lotos
makos116518362makos
manos74933622manos
mates75251362mates
maths105624022maths
mats65460292mat_s
matts76829182matts
matzos1749262matzos
mayos105521932mayos
naos47429732na_os
nates55238332nates
oaths86117312oaths
oats46554212oat_s
ottos54714322ottos
pantos85222742pantos
pates76047892pates
pathos115516692pathos
paths105521382paths
patios85221782patios
patois84319362patois
pats66460852pat_s
qats135331342qat_s
rates55352012rates
ratios64922672ratios
rato45436972rato_
rats46260372rat_s
rotos56027882rotos
sagos66123872sagos
santos64421832santos
saros55238062saros
sates54949322sates
satis55633682satis
tacos77023552tacos
taos45541002ta_os
taros55640822taros
tates55444982tates
tats46858132tat_s
vats76841742vat_s
vatus86114642vatus
wats77555882wat_s
watts86923092watts

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 Limit538001631.71631352.0
3Display Results1631630.0463543.5
 (SQL Overall)1786911632.07586116.1
 
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.