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

151 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
dagos7641944(None) 
dados75522431dados
dago65725091dago_
dagoes85714601dagoes
dags66642601dag_s
datos65222781datos
sagos66123871sagos
abos67734412_abos
adages8412952adages
adagios945512adagios
adios65822862adios
ados57633512_ados
agas55938842_agas
ages55844592_ages
agios65919862_agios
ago48845522_ago_
agog68019002_agog
agon56531882_agon
agons66423782_agons
ags47551662_ag_s
apos65433822_apos
avos77227012_avos
bags76645502bag_s
bigos85020012bigos
cages85936012cages
calos74431902calos
camos95927612camos
capos94826072capos
cargos94619182cargos
dabs77139402da_bs
daces85030682daces
dadas75819862dadas
dado67126332dado_
dadoes85616532dadoes
dads67442772da_ds
daffs125116422daffs
dag57753012dag__
dagga839542dagga
daggas937972daggas
dagoba1074942dagoba
dagobas1145142dagobas
dahls95012282dahls
dahs88231812da_hs
dais57040702da_is
daks97130602da_ks
dales66439742dales
dals57145122da_ls
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372da_ms
dangs75623202dangs
danios7314602danios
dans56748152da_ns
daps77239162da_ps
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
dates65639152dates
dato56129942dato_
dattos74311902dattos
daubs85014562daubs
dauts67822242dauts
dawks135213492dawks
dawns95916592dawns
daws86638242da_ws
dawts97216122dawts
days87637132da_ys
dazes155024142dazes
decos85522122decos
degas75119162degas
demos86022992demos
didos76820812didos
digs66036052dig_s
dinos65428062dinos
dodos75819392dodos
doges75630162doges
dogs66440152dog_s
dojos135111792dojos
dos48062312d__os
dragon838842dragon
dragons938382dragons
drags75521112drag_s
dugs614832282dug_s
duos56728132d_uos
duros65422692duros
egos55821652_egos
fados95620732fados
fagot9323402fagot
fagots1039962fagots
fags86939122fag_s
fanos85926502fanos
faros85532022faros
gages74529972gages
gags66441062gag_s
gogos77516522gogos
gos47155132__gos
hags86740842hag_s
halos85230252halos
imagos9117552imagos
jaggs148111492jaggs
jags126132792jag_s
jatos125116822jatos
kagus105812032kagus
kayos127714702kayos
lags56546222lag_s
largos74815062largos
logos67225332logos
mages85036022mages
magot8326392magot
magots9312362magots
mags75444532mag_s
magus85318752magus
makos116518362makos
mangos94319332mangos
manos74933622manos
mayos105521932mayos
nags55436022nag_s
naos47429732na_os
pages85235072pages
pagod95013682pagod
pagods105310192pagods
pargos95719042pargos
ragas65326062ragas
rages64539442rages
raggs75216472raggs
ragis66325602ragis
rags55448372rag_s
ratos55528762ratos
sagas66025882sagas
sages65339062sages
sago56332672sago_
sags55948402sag_s
sargos74318272sargos
saros55238062saros
segos64919482segos
tacos77023552tacos
tags55545232tag_s
tangos74216302tangos
taos45541002ta_os
taros55640822taros
vagus96713812vagus
wages95330932wages
wagon94312952wagon
wagons103911212wagons
wags86140552wag_s
yagis95416572yagis
yags86632292yag_s
zags146826682zag_s

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.296603685.8
2DLD Change Limit538001511.61033416.1
3Display Results1511510.0334575.8
 (SQL Overall)1786911511.93992156.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.