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

136 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
ruby9781994(None) 
rub56342821rub_
rubby124413861rubby
rube65532011rube
rubs66133491rubs
rugby11448131rugby
ruly76323141ruly
aby810238062_aby
baby116723682baby
brumby15385952brumby
bub76343982bub_
bubby115013932bubby
bubo85621912bubo
bubs86235502bubs
bubu85022672bubu
buoy95921782buoy
bury95633592bury
busby126113292busby
busy94727172busy
buy86436542bu_y
by77529232__by
crumby15408112crumby
cub76940942cub_
cubby145212122cubby
cube85830212cube
cubs85832382cubs
dauby115211222dauby
doby106022162doby
drub75920132drub_
drubs85913832drubs
dub66642202dub_
dubs78432192dubs
duly85323032duly
duty85321452duty
fub86337392fub_
fubs96328792fubs
fubsy13589272fubsy
fumy127118582fumy
fury107727972fury
gaby107123192gaby
goby106021082goby
grub77220082grub_
grubby14324502grubby
grubs86312602grubs
guy75728942gu_y
hub86437482hub_
hubby155011402hubby
hubs96027142hubs
inby95315662inby
juba134916982juba
jube136322782jube
jury146719592jury
krubi1136522krubi
lube64731562lube
luny77324132luny
nub56439142nub_
nubby125011032nubby
nubs65927142nubs
orby97519602orby
outby10411532outby
pub76037692pub_
pubs85029212pubs
puny95526992puny
quay164618352quay
quey164616472quey
racy95825682racy
ray66361992r_ay
reb55844962reb_
rebs65733562rebs
rebuy104714682rebuy
rely75428952rely
rib56848032rib_
ribby12419682ribby
ribs65833022ribs
rimy96621282rimy
rob56754302rob_
robe65335642robe
robs65837872robs
ropy96323412ropy
rosy76024872rosy
roupy106112712roupy
rubbly133710612rubbly
rubel75416832rubel
rubes74928412rubes
ruble74521252ruble
rubus76415062rubus
ruck104728332ruck
rudd65917472rudd
ruddy104511752ruddy
rude55632782rude
rue35549262ru_e
rued55729792rued
ruer46127562ruer
rues46044482rues
ruff105127652ruff
rug46039152ru_g
ruga56121232ruga
rugs56033682rugs
ruin47430512ruin
rule49938422rule
rum56644642ru_m
rumba93612512rumba
rumbly134412162rumbly
rummy124212412rummy
rump86729082rump
rums64833472rums
run36244982ru_n
rune45236292rune
rung56429972rung
runny84613482runny
runs46438072runs
runt46647982runt
runty86119042runty
ruse45938932ruse
rush76628182rush
rushy115414812rushy
rusk85823312rusk
rust45544912rust
rusty85221052rusty
rut35560522ru_t
ruth76825992ruth
ruts44541492ruts
rutty85617802rutty
sub55445552sub_
suba64926602suba
subs66037122subs
toby96322292toby
truly84111552truly
tub55640032tub_
tuba65422362tuba
tubby124511402tubby
tube65828662tube
tubs65430062tubs
upby1139062upby
urb55731102urb_
urbs65922052urbs

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.0802233637.5
2DLD Change Limit298721360.89033564.0
3Display Results1361360.0462956.5
 (SQL Overall)1786911361.016175877.0
 
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.