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

240 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
ratables1015972(None) 
eatables10169791eatables
ratable91717551ratable_
retables101712671retables
arables91814982_arables
datable101714232datable_
eatable91717602eatable_
hatable121713962hatable_
notables10178242notables
parables121613572parables
payables15166492payables
potables12179702potables
rabbles113517972ra_bbles
rambles113118312ra_mbles
ratably121711512ratabl_y
ratafees1144142ratafees
ratals64219582rata_l_s
ratanies8312922ratanies
rateable10311442rateable_
ratholes11312412ratholes
rattles73217302rat_tles
restables111511422restables
retable91820402retable_
stables93219072_stables
tables84524892__tables
taxables1734382taxables
abatable1238023abatable_
ables75935543___ables
actable11313473actable_
ambles105121863_a_mbles
anableps1243123_anableps
arable81821003_arable_
articles10310253articles
atabals938413_atabals
ataxies142410013_ataxies
babbles104416323ba_bbles
battles94517683bat_tles
baubles113611863ba_ubles
beatable121612243beatable_
bitable11312203bitable_
boatable121610263boatable_
brabbles11349753bra_bbles
brambles14308973bra_mbles
brattles10199333brat_tles
breakables1842753breakables
cables104527553__cables
cantabiles1445763cantabiles
capable13313363capable_
capabler1435363capabler
capablest1544893capablest
cartable121314093cartable_
cascables15165773cascables
castable121613973castable_
cataloes10311653cataloes
catalos9414163cata_los
citable11313463citable_
creatable1339563creatable_
dabbles124514773da_bbles
database1143533database
databases1243913databases
dataries9314033dataries
dateable1149443dateable_
disables11410903disables
drabbles13308523dra_bbles
draftable1575563draftable_
drapable1377573drapable_
drawable1467113drawable_
durables11237013durables
enables92813123_enables
erasable10511043erasable_
fables114921673__fables
fadable13310463fadable_
framable1537573framable_
gabbles124415413ga_bbles
gables94222333__gables
gambles124016203ga_mbles
garbles104016923ga_rbles
gazaboes2043873gazaboes
getable101712553getable_
giftables1572593giftables
grabbles13339893gra_bbles
gradable1238823gradable_
grantable1257293grantable_
grazable2036223grazable_
gustables12165223gustables
hateable1339373hateable_
heatable131612043heatable_
jacales16310323jaca_les
lavaboes1344433lavaboes
makable15510203makable_
manacles1239523manacles
marbles114516653ma_rbles
movables15175573movables
mutable11312303mutable_
namable11312343namable_
notable92114903notable_
outfables1485563outfables
parable111819783parable_
payable141711323payable_
portables1337873portables
potable112115363potable_
prattles10189413prat_tles
probables1545433probables
rabbies113416053ra_bbies
rabble103818243ra_bble_
rabbled123514423ra_bbled
rabbler113514093ra_bbler
rabblers123810853ra_bblers
rabies85226023r__abies
raddles93615703ra_ddles
radiable11611303radiable_
radicles11249703radicles
raffles133611853ra_ffles
raggles93813283ra_ggles
raisable10311643raisable_
rales54947493r__a_les
ramblas112710263ra_mblas
ramble104519973ra_mble_
rambled123913523ra_mbled
rambler113313263ra_mbler
ramblers124010373ra_mblers
rampoles1238893rampoles
rankles113114553ra_nkles
rassles73513923ra_ssles
ratafee1047523rata_fee
ratafias1145323ratafias
ratal55025113rata_l__
ratans63819373rata__ns
rataplan1043633rataplan
rataplans1143823rataplans
ratatats846063ratatats
ratbags1035763rat_bags
ratches123620463rat_ches
rateably1337783rateabl_y
ratels64518213rat_el_s
rates55352013rat___es
rathole10312053rathole_
ratifies11313513ratifies
ratines75328583rat_ines
ratites74920683rat_ites
ratlines83815293ratlines
ratsbanes1194163ratsbanes
rattailed1084213rattailed
rattails837133rattail_s
rattle64717613rat_tle_
rattled84012953rat_tled
rattler74012743rat_tler
rattlers83510293rat_tlers
ravages1139403rava_ges
readable11313163readable_
reales64934123r_ea_les
reapable12311393reapable_
regales83520793rega_les
relabels1045343relabels
relatable11310053relatable_
reliables1145903reliables
rentable101716333rentable_
resales74724903resa_les
restable101618443restable_
restabled12148963restabled
retackles1545363retackles
retailed94113963retailed
retailer82911573retailer
retailers9258773retailers
retails74718973retail_s
retakes113718863reta_kes
retallies939373retallies
retapes93917423reta_pes
retastes82212903retastes
retaxes143615093reta_xes
reticles103912483reticles
retiles74426993ret_iles
retitles83612593retitles
reusables1175223reusables
rhatanies1244983rhatanies
ridable101412493ridable_
risibles1035783risibles
robles85321693r__obles
ropable111611333ropable_
rotaries8315693rotaries
rotatable1146653rotatable_
rotates72819773rota_tes
roubles93413513r_oubles
rowable121510303rowable_
rubbles113715113r_ubbles
rubles83921703r__ubles
rulable9310533rulable_
rumbles114018393r_umbles
rustable101511363rustable_
rutiles74315843rut_iles
sables85026693__sables
salable91415463salable_
satiable10310733satiable_
savable121711863savable_
sayable121411613sayable_
sparables13167173sparables
stabiles10311403_stabiles
stable83921643_stable_
stabled103514953_stabled
stabler94014933_stabler
stablers103611153_stablers
stablest103312943_stablest
stales65538293_sta_les
staples93617213_staples
statable10310703statable_
tabes76033923__tab_es
tablas83716163__tablas
table75429603__table_
tabled94020043__tabled
tablet84227643__tablet
tablets94714383__tablets
takable13310193takable_
tales55451373__ta_les
tamable11312853tamable_
tamales93216153tama_les
tastable101511973tastable_
tattles73616283tat_tles
taxable1639073taxable_
totable92313363totable_
tractable1338513tractable_
tradable1139873tradable_
treatable1139323treatable_
turntables1242263turntables
valuables1442973valuables
variables1444683variables
vocables15145733vocables
votable122111373votable_
wabbles144013993wa_bbles
wadable13310233wadable_
wambles143714023wa_mbles
warbles123215563wa_rbles
washables17144743washables
wastable131410453wastable_
watapes12228383wata_pes
watchables2043203watchables
wattles103814073wat_tles
waxable1937673waxable_
wearables14155013wearables
worktables1942613worktables
writable1338753writable_

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 Filter1786911461620.440406115.9
2DLD Change Limit1461622407.42019698.4
3Display Results2402400.1102181.8
 (SQL Overall)1786912407.97022420.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.