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

161 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
reb55844961reb
rib56848041rib
rob56754301rob
rub56342821rub
rya67622011rya
rye66032541rye
ab410674762_ab
aby810238062aby
alb57342652alb
arb510448422arb
aryl75922342aryl
ay511773892ay_
aye67151762aye
ays67050292ays
bib77045952bib
bob76755672bob
bub76343982bub
by77529232by_
bye86134592bye
bys85229462bys
cab78355402cab
cob710258752cob
crab85727672crab
crib86323582crib
cry89726242cry_
cub76940942cub
dab67455562dab
deb66342692deb
dib65746952dib
drab76226452drab
drib76823262drib
drub75920132drub
dry76526032dry_
drys86314802drys
dub66642202dub
dye75334842dye
ebb72418632ebb
eye65539772eye
fab87453132fab
fib86344282fib
fob86748332fob
fry96226502fry_
fub86337392fub
gab67155992gab
gib66443542gib
gob68950892gob
grab75427612grab
grub77220082grub
gybe105916242gybe
gym95719062gym
gyp98319012gyp
hob87550922hob
hub86437482hub
hyp117822462hyp
jab128444112jab
jib125835982jib
job128041772job
kab97145862kab
kob99442392kob
kye107327282kye
lab58864782lab
lib57750282lib
lob57154462lob
lye66533412lye
mib76946132mib
mob78651922mob
my78125652my_
myc106519502myc
nab56954922nab
neb57238622neb
nib56745202nib
nob58954422nob
nub56439142nub
orb55736862orb
orby97519602orby
oryx14510212oryx
oy58950132oy_
pry85728052pry_
pub76037692pub
pya87023752pya
pye86432502pye
pyx157817012pyx
rad47662012rad
rag45761322rag
rah68052402rah
rai37658222rai
raj105740222raj
ram56867272ram
ran38266622ran
rap56261962rap
ras37575392ras
rat37892742rat
raw67252252raw
rax108445722rax
ray66361992ray
raya75224822raya
rays77642352rays
re26153742r_e
rebs65733562rebs
rec55645462rec
red46755812red
ree37974072ree
ref66053292ref
reg46146492reg
rei35647252rei
rem56150042rem
rep55847802rep
res35565042res
ret35982832ret
rev65336622rev
rex105740992rex
rho65924832rho
ria36745512ria
ribs65833032ribs
rid46754642rid
rif65951572rif
rig46748132rig
rim56052282rim
rin36663192rin
rip56851312rip
robe65335642robe
robs65837872robs
roc520243252roc
rod47953902rod
roe36861082roe
rom59855632rom
rot37282952rot
row67453672row
rube65532012rube
rubs66133492rubs
ruby97819942ruby
rue35549262rue
rug46039152rug
rum56644642rum
run36244992run
rut35560522rut
ryas77224612ryas
ryes75529352ryes
ryke115616402ryke
rynd86414102rynd
ryot75528562ryot
sab56563202sab
sib56850322sib
sob57857942sob
sub55445552sub
sybo9714742sybo
syn67024122syn
tab57460322tab
try66529672try_
tub55640032tub
tye65837442tye
urb55731112urb
wab87051832wab
web85735562web
wry96524702wry_
wye96331972wye
wyn95921442wyn
ya510251502_ya
ye57650062_ye
yo59748552_yo
yob87945272yob

Search took 1 second 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 Filter178691140840.250714764.0
2DLD Change Limit140841610.37637457.4
3Display Results1611610.0305366.7
 (SQL Overall)1786911610.656272394.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.