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

130 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
rubasses103549(None) 
rubasse934901rubasse_
basses85428302__basses
quasses16209502qu_asses
repasses101810372repasses
rubaces1139312ruba_ces
subbasses1345222subbasses
abases85720773_aba_ses
abashes12510373_abashes
abbesses1235333abbesses
abysses1234863_abysses
admasses1135413admasses
amasses93912853_amasses
asses55629283___asses
aubades1038753auba_des
avgasses1284193avgasses
baases85218013__baases
babassus1243063babassus
badasses1136173badasses
bagasses1136313bagasses
bases75644353__ba_ses
bashes115631393__bashes
basset85225383__basset
bassets96414823__bassets
bassos85313703__bassos
bastes85330383__bastes
biasses94911653_biasses
bosses85925403__bosses
brasses93818353_brasses
bubales113513343buba_les
bubalises1346323bubalises
busses85023383__busses
bypasses1533833bypasses
camasses12388973camasses
chasses124017503_chasses
classes94717943_classes
crevasses1444133crevasses
cubages1237923cuba_ges
cuirasses1144373cuirasses
cuisses9319883cu_isses
cusses84522773cu__sses
cutlasses1145103cutlasses
debases103814133deba_ses
degasses10278363degasses
duresses939173duresses
embassies1344003embassies
embosses1235963embosses
eyasses10388023_eyasses
frasses104314513_frasses
fusses94920553fu__sses
gasses75724783__gasses
glasses84414273_glasses
grasses84117343_grasses
guesses8169373gu_esses
harasses11311033harasses
hubrises1337103hubrises
impasses12257523impasses
judases1534443juda_ses
kavasses1544303kavasses
kumisses1443583kumisses
kurbashes1883523kurbashes
kvasses14365503_kvasses
lasses64827593__lasses
masses85028713__masses
megasses11307743megasses
molasses1037233molasses
morasses1038903morasses
musses84624783mu__sses
mutases92012043muta_ses
outgasses1036663outgasses
outpasses1146613outpasses
passes86030473__passes
pusses84322843pu__sses
quashes192110973qu_ashes
raises64826543r__aises
rases55447213r__a_ses
rashes95330153r__ashes
rassles73513923r__assles
reassess836513r_eassess
rebates95123183reba_tes
rebuses94915293reb_uses
recesses10312323recesses
rehashes1436953rehashes
relapses1038033relapses
repassed11229273repassed
reraises8415643reraises
retastes82212903retastes
rewashes1447033rewashes
ribgrasses1342943ribgrasses
riboses9310443rib_oses
rubaboos1242653rubaboos
rubace10310173ruba_ce_
rubatos9278653ruba_tos
rubbies114114113rub_bies
rubbishes1644303rubbishes
rubbles113715113rub_bles
rubes74928413rub___es
rubies84420343rub__ies
rubles83921703rub__les
ruckuses1444913ruckuses
rumpuses1235163rumpuses
ruralises939123ruralises
ruses56136583ru___ses
rushes94724363ru__shes
russet6319433ru__sset
russets738163ru__ssets
sasses64124393__sasses
strasses81311443strasses
subbases1239063subbases
subcastes1387493subcastes
subcauses1346213subcauses
subclasses1444743subclasses
subsales10310123subsales
surbases10310003surba_ses
surpasses1145533surpasses
susses64221053su__sses
tasses64826763__tasses
trasses74819323_trasses
trusses73813633tru__sses
tubaists1055103tubaists
tusses64921243tu__sses
ukases10358063_uka_ses
upases84112903_upa_ses
urases63723563_ura_ses
urbanises11106643urbanises
ureases74416723urea_ses
vinasses1135703vinasses
wrasses103812593_wrasses
wusses93314893wu__sses
zebrasses2043513zebrasses

Search took 10 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621308.95316325.5
3Display Results1301300.0462826.1
 (SQL Overall)1786911309.15519518.4
 
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.