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

152 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
ruga5612123(None) 
juga126417321juga
raga55930811raga
rug46039151rug_
rugae65114761rugae
rugal65916091rugal
rugs56033681rugs
yuga85615421yuga
aga410447232_aga
ajuga1335882ajuga
alga57927602alga
anga56831352anga
aura45836252aura
brugh115414292brugh
bug65340742bug_
bugs76035912bugs
buna64730722buna
bura66139532bura
crura7312582crura
drug65718132drug_
drugs75214652drugs
dug58138692dug_
dugs614832282dugs
duma75524452duma
dura55232112dura
erugo6369852erugo
frug86517102frug_
frugal1036392frugal
frugs96114282frugs
fug76234512fug_
fugal95613032fugal
fugs85730692fugs
fugu85419862fugu
gaga66625552gaga
giga66720942giga
hug76037362hug_
huge86321652huge
hugs86129752hugs
hula74923752hula
juba134916982juba
jug115529542jug_
jugal135612402jugal
jugs125525602jugs
jura116024892jura
kuna85120702kuna
lug46138062lug_
luge55531642luge
lugs55233522lugs
luma65527522luma
luna46229852luna
mega77620872mega
mug65837692mug_
mugg86316012mugg
mugs76232042mugs
mura65633292mura
pruta7314242pruta
pug65337182pug_
pugh106619232pugh
pugs76332772pugs
puja135714922puja
pula65129372pula
puma85424122puma
puna65331652puna
pupa85422812pupa
qua124821972qu_a
quag144815942quag
rag45761322rag_
ragas65326062ragas
rage55742352rage
ragg65622692ragg
ragi56032282ragi
rags55448372rags
raia46638382raia
raja117918682raja
raya75224822raya
reg46146492reg_
regal65023792regal
regma84612332regma
regna64614812regna
regs55436572regs
rhea75017432rhea
ria36745502r_ia
rig46748122rig_
rigs55137592rigs
rota45834342rota
rouge65423442rouge
rough97819432rough
ruana5312422ruana
rub56342822ru_b
rube65532012rube
rubs66133492rubs
ruby97819942ruby
ruck104728332ruck
rudd65917472rudd
rude55632782rude
rue35549262ru_e
rued55729792rued
ruer46127562ruer
rues46044482rues
ruff105127652ruff
rugate75813812rugate
rugby11448132rugby
rugola736292rugola
rugosa734562rugosa
ruin47430512ruin
rule49938422rule
ruly76323142ruly
rum56644642ru_m
rumba93612512rumba
rump86729082rump
rums64833472rums
run36244982ru_n
rune45236292rune
rung56429972rung
rungs611819402rungs
runs46438072runs
runt46647982runt
rural55821172rural
ruse45938932ruse
rush76628182rush
rusk85823312rusk
rust45544912rust
rut35560522ru_t
ruth76825992ruth
ruts44541492ruts
rya67622012r_ya
saga55331172saga
suba64926602suba
sugar6312912sugar
sugh86423442sugh
sura45740292sura
toga57027412toga
trug55720042trug_
trugs65516802trugs
tuba65422362tuba
tufa75016612tufa
tug45937402tug_
tugs56231672tugs
tuna45127842tuna
ugh76520682_ugh
urea46528052urea
urge54722412urge
ursa44116902ursa
uta37425582_uta
viga85622962viga
vug76127412vug_
vugg95612712vugg
vugh117115722vugh
vugs87022872vugs
yoga87418052yoga
yuca95716722yuca
yugas95012062yugas

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 Filter178691298720.0632836365.1
2DLD Change Limit298721520.93631914.5
3Display Results1521520.0334606.1
 (SQL Overall)1786911521.032173150.2
 
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.