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

147 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
rabies8522601(None) 
babies106123641babies
gabies93820721gabies
rabbies113416051rabbies
ramies84630461ramies
rubies84420331rubies
abbes96723522_abbes
abides94719892_abides
ables75935542_ables
abyes105518532_abyes
amies76837682_amies
arabizes1969102arabizes
arables91814972arables
armies85123692armies
babes95834112bab_es
babied114913502babied
babier103515562babier
babiest114414752babiest
barbies114519592barbies
braxies16711462braxies
cabbies133115162cabbies
cabins104418912cabins
cables104527552cables
caries85147622caries
cavies114525002cavies
crazies183413852crazies
darbies104216982darbies
davies105020512davies
dobies94422082dobies
easies64126632easies
fables114921672fables
facies113921592facies
gables94222332gables
gobies95418052gobies
gravies11314092gravies
habits113014642habits
ladies75124882ladies
lambies113015102lambies
lazies154418782lazies
mabes96331532mab_es
mamies104626242mamies
mavies114923192mavies
nabes75427092nab_es
nabis76020572nabi_s
navies95218622navies
paries84742512paries
rabats83116222rabats
rabbet103818652rabbet
rabbets11279422rabbets
rabbins112811342rabbins
rabbis102613152rabbis
rabbits11299862rabbits
rabbles113517972rabbles
rabic93817392rabi_c
rabid84520772rabi_d
races74943242ra_ces
racier85120972racier
raciest92820012raciest
radices102314262radices
radios74018672radios
radius73914862radius
radixes15259342radixes
ragees74618662ragees
rages64539442ra_ges
raggies93214732raggies
ragis66325602ragi_s
raias54631122ra_ias
raids65827512ra_ids
rails55937402ra_ils
rains55140232ra_ins
rais45252622ra_i_s
raise54828052ra_ise
raises64826542raises
rajes125022782ra_jes
rakees104516972rakees
rakes94440352ra_kes
rakis95323442raki_s
rales54947492ra_les
rallies73823342rallies
rambles113118312rambles
ramees84620892ramees
ramie75027822ramie_
rances84625442rances
randies84225662randies
ranees64623962ranees
ranges73826922ranges
ranids75118702ranids
ranis55235832rani_s
rapes75740722ra_pes
raphes115117452raphes
rapids94913892rapids
rapier84019992rapier
rapiers95012872rapiers
rapines95120862rapines
rares55247442ra_res
rases55447212ra_ses
rashes95330152rashes
rates55352012ra_tes
ratines75328582ratines
ratios64922672ratios
ratites74920682ratites
raves85441972ra_ves
ravines104220232ravines
ravins94622562ravins
rawins95617622rawins
raxes124729392ra_xes
razees154314762razees
razes145032702ra_zes
razzes144910062razzes
readies83324702readies
rebbes10313532rebbes
rebids94015522rebids
relies65036422relies
reties65436192reties
ribes75530172rib_es
ribier84414222ribier
ribiers9319752ribiers
roadies83317432roadies
robes75133302rob_es
robins83617442robins
robles85321692robles
rubbies114114112rubbies
rubes74928412rub_es
rubied94312402rubied
rubier84814732rubier
rubiest92914422rubiest
rubles83921702rubles
rugbies10339352rugbies
sabes76437462sab_es
sabines94318482sabines
sabins85521972sabins
sabirs85414622sabirs
sables85026692sables
sabres85520862sabres
sanies63031952sanies
scabies11613332scabies
tabbies112913502tabbies
tabes76033922tab_es
tables84524882tables
taxies135817332taxies
tobies84521012tobies
varies94330872varies
wadies105121202wadies
walies95324522walies
wavies125019842wavies
yabbies14279642yabbies
zanies153219672zanies

Search took 5 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.1261418182.5
2DLD Change Limit825511473.97020793.7
3Display Results1471470.1101336.4
 (SQL Overall)1786911474.20642484.8
 
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.