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

134 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
robles8532169(None) 
cobles104622881cobles
nobles83319721nobles
robes75133301rob_es
roble75223021roble_
roles56747981ro_les
roubles93413511roubles
rubles83921701rubles
ables75935542_ables
ambles105121862ambles
arables91814972arables
bibles104617642bibles
bobbles104514912bobbles
bogles95020832bogles
boles75448602bo_les
boules84925972boules
cables104527552cables
cobbles133814822cobbles
coble94823172coble_
coles76055062co_les
dobies94422092dobies
doblas93812292doblas
doles67843752do_les
doubles103113352doubles
fables114921672fables
foibles1238852foibles
folles93820472folles
gables94222332gables
gobbles123512582gobbles
gobies95418062gobies
goblet93219482goblet
goblets103210182goblets
goboes95914442goboes
hobbles143313782hobbles
hoboes114717442hoboes
holes84748652ho_les
hoyles12315012hoyles
jobless16237562jobless
joles125230832jo_les
joules134116822joules
lobes75331002lob_es
lobules92510812lobules
mobiles112813122mobiles
mobled113213182mobled
moles74747922mo_les
nobbles114014522nobbles
noble74420992noble_
nobler83713452nobler
noblest93613562noblest
nombles113212342nombles
obes66036832_ob_es
oboes75717712_oboes
oboles83815832_oboles
ogles65223182_ogles
oles46453472_o_les
oodles73517182oodles
orbless937492orbless
orles55326212_orles
poles75351002po_les
probes104119452prob_es
problem1335982problem
problems1434342problems
proles84627202pro_les
rabbles113517972rabbles
rabies85226022rabies
rales54947492r_ales
rambles113118312rambles
reales64934122reales
rebbes10313532rebbes
rebels84518132rebels
ribes75530172rib_es
ribless93410342ribless
riblet84222442riblet
riblets93412552riblets
rifles94217702rifles
riles55343642r_iles
rilles64725502rilles
robalos937682robalos
robbed113415192robbed
robber103916532robber
robbers112814162robbers
robe65335642rob_e_
robed85323732rob_ed
robins83617452robins
robots8313152robots
robs65837872rob__s
rodes614039082ro_des
rodless8310072rodless
roes45954142ro__es
rogues74617672rogues
roiled74320052roiled
roils54826792roil_s
role45851822ro_le_
rolfs84817122ro_lfs
rolled74220242rolled
roller63919792roller
rollers73117472rollers
rolls55326232ro_lls
rooses65526232rooses
rootles73215632rootles
ropes75940062ro_pes
roques154912562roques
roses56445772ro_ses
rotes56143902ro_tes
rotls55620162rotl_s
rottes64524832rottes
rouble83913312rouble_
roues56039352ro_ues
rouges76022382rouges
rouses65436282rouses
routes66129312routes
roves84834482ro_ves
rowels94515452rowels
rubbles113715112rubbles
rubels84112992rubels
rubes74928412rub_es
rubies84420342rubies
ruble74521252ruble_
rules55234252r_ules
rumbles114018392rumbles
sables85026692sables
socles8418452socles
soles55547922so_les
tables84524892tables
tobies84521022tobies
toiles63923512toiles
toles55147132to_les
trebles9311442trebles
troubles1057202troubles
umbles103817492umbles
voiles94616442voiles
voles86234042vo_les
wobbles143412432wobbles
yodles103714332yodles

Search took 4 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.343520965.0
2DLD Change Limit825511342.67330883.3
3Display Results1341340.0304466.7
 (SQL Overall)1786911343.04658664.1
 
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.