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

120 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
rubles8392170(None) 
robles85321691robles
roubles93413501roubles
rubbles113715111rubbles
rubels84112991rubels
rubes74928411rub_es
rubies84420331rubies
ruble74521251ruble_
rules55234251ru_les
rumbles114018391rumbles
ables75935542_ables
ambles105121852ambles
arables91814972arables
baubles113611862baubles
bibles104617642bibles
bubales113513342bubales
bubbles104315962bubbles
bubkes144612622bubkes
buboes104513992buboes
bugles94822442bugles
bumbles134016842bumbles
burbles114916802burbles
butles84423912butles
cables104527552cables
cobles104622882cobles
crumbles14329682crumbles
cubes95028162cub_es
doubles103113352doubles
drumbles13277722drumbles
fables114921672fables
fugles104715782fugles
fumbles143514412fumbles
gables94222332gables
grumbles13288872grumbles
guiles73919282guiles
gules64831042gu_les
humbles143215802humbles
jubes145420742jub_es
jubiles16289372jubiles
jumbles183013322jumbles
lubes74727992lub_es
mules75034292mu_les
mumbles133014432mumbles
nobles83319722nobles
nubbles113412432nubbles
numbles113814272numbles
pubes94423402pub_es
pules74538812pu_les
rabbles113517972rabbles
rabies85226012rabies
rales54947492r_ales
rambles113118312rambles
reales64934122reales
rebbes10313532rebbes
rebels84518132rebels
ribes75530172rib_es
ribless93410342ribless
riblet84222442riblet
riblets93412552riblets
rifles94217702rifles
riles55343642r_iles
rilles64725502rilles
robes75133302rob_es
roble75223022roble_
roles56747982r_oles
rouble83913312rouble_
rubaces1139302rubaces
rubbed114515082rubbed
rubber104715792rubber
rubbers113913182rubbers
rubbies114114112rubbies
rubble104315672rubble_
rubbled124611622rubbled
rube65532012rub_e_
rubel75416832rub_el
rubied94312402rubied
rubier84814732rubier
rubiest92914422rubiest
rubs66133492rub__s
rubus76415052rub_us
ruches114819582ruches
ruckles133414602ruckles
ruddles92813872ruddles
rues46044482ru__es
ruffes124112422ruffes
ruffles133512262ruffles
rugbies10339352rugbies
rule49938422ru_le_
ruled65822522ru_led
ruler54923342ru_ler
rulers64317092ru_lers
rumble103718812rumble_
rumbled124514592rumbled
rumbler113514112rumbler
rumblers123610742rumblers
rumples113313132rumples
rundles83214712rundles
runes55530222ru_nes
runkles114111942runkles
runless72810422runless
runlet63821412runlet
runlets73310772runlets
rupees8312572rupees
ruses56136582ru_ses
rushes94724362rushes
rustles73416412rustles
rutiles74315842rutiles
sables85026692sables
sublet82827242sublet
sublets92616702sublets
tables84524882tables
trebles9311442trebles
troubles1057182troubles
tubes74826452tub_es
tubules9310232tubules
tules54532792tu_les
tulles63218892tulles
tumbles113816022tumbles
umbles103817482umbles
yules84521582yu_les

Search took 6 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 Filter178691825510.233766914.2
2DLD Change Limit825511204.75017379.2
3Display Results1201200.0462608.7
 (SQL Overall)1786911205.02935532.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.