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 “rubasse” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
rubasse93490(None) 
rubasses1035491rubasses
rubace10310172ruba_ce
rubaces1139312rubaces
abase76023483_aba_se
abases85720773_abases
aubade939223auba_de
aubades1038753aubades
babassu1153463babassu
bagasse1035143bagasse
base64847023__ba_se
bases75644353__bases
bass66146783__bass_
basses85428303__basses
basset85225383__basset
bassi77019323__bassi
basso76017283__basso
bassy1012917103__bassy
baste74829983__baste
bubale104014623buba_le
bubales113513343bubales
bubals103513843bubals_
chasse115114603_chasse
crevasse1343093crevasse
cubage1178273cuba_ge
cubages1237923cubages
cuisse8318333cu_isse
debase94014473deba_se
debases103814133debases
embassy1442703embassy
impasse11246463impasse
jubas144614223juba_s_
judases1534443judases
masse75125293__masse
megasse10266243megasse
mutase82811993muta_se
mutases92012043mutases
passe75525693__passe
quass144413763qu_ass_
quasses16209503qu_asses
rabats83116223rabats_
raise54828053r__aise
rase46149983r__a_se
rases55447213r__ases
rassle63813203r__assle
rebars84019833rebars_
rebate84424113reba_te
rebates95123183rebates
rebuses94915293rebuses
relapse947703relapse
repass84114703repass_
repassed11229273repassed
repasses101810373repasses
reraise7316313reraise
retaste72313133retaste
ribose839893rib_ose
riboses9310443riboses
rubaboo1144093rubaboo
rubati8299693ruba_ti
rubato8319683ruba_to
rubatos9278653rubatos
rubbies114114113rubbies
rubbish1436303rubbish
rubble104315673rub_ble
rubbles113715113rubbles
rube65532013rub___e
rubels84112993rubels_
rubes74928413rub_es_
rubies84420343rubies_
rubiest92914423rubiest
ruble74521253rub__le
rubles83921703rubles_
rubs66133493rub__s_
rubus76415063rub_us_
rugae65114763ruga__e
rugate75813813ruga_te
rugose737283ru_gose
rulable9310533rulable
rumbas102512013rumba_s_
ruralise839643ruralise
ruse45938933ru___se
ruses56136583ru__ses
russet6319433ru__sset
subahs114512383subahs_
subas74724073suba_s_
subbase1139323subbase
subbases1239063subbases
subbass1138033subbass_
subbasses1345223subbasses
subcaste1287853subcaste
subcause1265823subcause
subsale9310543subsale
surbase939793surba_se
surbases10310003surbases
tasse54821843__tasse
tubae74716643tuba__e
tubaist938703tubaist
tubas75119583tuba_s_
tubate82813173tuba_te
ukase9428493_uka_se
ukases10358063_ukases
upases84112903_upases
urase54624693_ura_se
urases63723563_urases
urbane82211383urba_ne
urbanise10107283urbanise
urease64516993urea_se
ureases74416723ureases
vinasse1044513vinasse
wrasse9398773_wrasse

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271106.67320085.0
3Display Results1101100.0631746.0
 (SQL Overall)1786911107.14225019.7
 
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.