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

217 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
ratos5552876(None) 
datos65222781datos
jatos125116821jatos
rates55352011rates
ratios64922671ratios
rato45436971rato_
rats46260371rat_s
rotos56027881rotos
abos67734412_abos
ados57633512_ados
altos55822952altos
apos65433822_apos
arts49650262art_s
arvos86015662arvos
ates45047922_ates
atom67824522_atom
atoms76817562_atoms
atop66124752_atop
autos56523322autos
avos77227012_avos
bates75846342bates
bathos116215632bathos
baths105922922baths
baton75822422baton
batons85519422batons
bats66962332bat_s
batts76727562batts
brats75336012brat_s
bravos114711392bravos
calos74431902calos
camos95927612camos
cantos84826972cantos
capos94826072capos
cates75951892cates
cats66356342cat_s
crates85736062crates
craton84517192craton
cratons94316032cratons
dados75522432dados
dagos76419442dagos
dates65639152dates
dato56129942dato_
dattos74311902dattos
drats66628372drat_s
eats47054872eat_s
fados95620732fados
fanos85926502fanos
faros85532022faros
fates85139232fates
fats76252502fat_s
fatso85113492fatso
fatsos9389422fatsos
frats86829672frat_s
gates65939512gates
gator64416042gator
gators74115842gators
gats56753442gat_s
grates75429892grates
gratis74819242gratis
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
orates64328612orates
orator6314532orator
orators7313822orators
ottos54714322ottos
pantos85222742pantos
pates76047892pates
pathos115516692pathos
paths105521382paths
patios85221782patios
patois84319362patois
pats66460852pat_s
praos74923562pra_os
prates84633162prates
prats76333392prat_s
qats135331342qat_s
rabatos93010902rabatos
races74943242races
racks115028852racks
racon75422142racon
racons84319342racons
radios74018672radios
radon64620502radon
radons74118532radons
rads56046602ra_ds
raffs115017522raffs
rafts87820632rafts
ragas65326062ragas
rages64539442rages
raggs75216472raggs
ragis66325602ragis
rags55448372ra_gs
ragtop936682ragtop
ragtops1035452ragtops
raias54631122raias
raids65827512raids
rails55937402rails
rains55140232rains
rais45252622ra_is
raitas64417672raitas
rajas127317722rajas
rajes125022782rajes
rakes94440352rakes
rakis95323442rakis
rakus94413672rakus
rales54947492rales
ramose8314402ramose
ramous8417112ramous
ramps96224632ramps
rams65950772ra_ms
ramus76418282ramus
rands65930452rands
ranis55235832ranis
ranks95225732ranks
rants55935342rants
rapes75740722rapes
raps66247732ra_ps
raptor83912822raptor
raptors94213352raptors
rares55247442rares
ras37575392ra__s
rases55447212rases
rasps74316662rasps
rat37892742rat__
ratal55025112ratal
ratals64219582ratals
ratan53722662ratan
ratans63819372ratans
ratch104221362ratch
rate45458762rat_e
rated65441382rated
ratel54224882ratel
ratels64518212ratels
rater54943282rater
raters63936582raters
rath76037662rat_h
rathe85821922rathe
ratio55227582ratio
ration64226012ration
rations74123432rations
ratoon64417372ratoon
ratoons73815472ratoons
ratton64116122ratton
rattons73815322rattons
ratty84819592ratty
raves85441972raves
raws75238212ra_ws
raxes124729392raxes
rayas85922052rayas
rayon83815702rayon
rayons94113342rayons
rays77642352ra_ys
razes145032702razes
razor143012602razor
razors154711662razors
reatas64021012reatas
rebatos92913112rebatos
rectos85718782rectos
redos65126762redos
repos74725792repos
retros63820192retros
rets45352562ret_s
rhos76319062r_hos
rialtos736612rialtos
riatas63915092riatas
riots54922012riots
rites54442552rites
roots55933672roots
rotas54827722rotas
rotes56143902rotes
rotis56327062rotis
rotls55620162rotls
roto45935052roto_
rotor55519732rotor
rotors64917952rotors
rots46454092rot_s
rubatos9278652rubatos
ruths85714642ruths
ruts44541492rut_s
ryots85313782ryots
sagos66123872sagos
santos64421832santos
saros55238062saros
sates54949322sates
satis55633682satis
tacos77023552tacos
taos45541002ta_os
taros55640822taros
tates55444982tates
tats46858132tat_s
urates65027762urates
vats76841742vat_s
vatus86114642vatus
wats77555882wat_s
watts86923092watts
wraths123810082wraths

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 Limit538002171.71631352.0
3Display Results2172170.0633444.4
 (SQL Overall)1786912172.09285416.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.