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

194 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
durables1123701(None) 
durable102312721durable_
arables91814972_arables
burbles114916802bur_bles
burnables1344002burnables
curable112414512curable_
disables11410902disables
drabbles13308522d_rabbles
drumbles13277722drumbles
dupable12238382dupable_
durably13229052durabl_y
durances1158682durances
educables1443472educables
parables121613562parables
ables75935543___ables
adorable1138773adorable_
arable81821003_arable_
audibles11215533audibles
aureoles838283aureoles
auricles10138333auricles
brabbles11349753_brabbles
brambles14308973_brambles
bubales113513343buba_les
bubbles104315963bu_bbles
bumbles134016843bu_mbles
burble104617703bur_ble_
burbled124312673bur_bled
burbler114412423bur_bler
burblers12399263bur_blers
burgles105615963bur_gles
burnable1237263burnable_
buyable1437493buyable_
cables104527553__cables
coracles121811163coracles
cradles103114133_cradles
crumbles14329683crumbles
curably142010773curabl_y
curacies12311763curacies
curares94916853cura_res
curates95323833cura_tes
curbable1447663curbable_
curdles103814573cur_dles
dabbles124514773d_abbles
dales66439743d__a_les
dalles74222063d__alles
darbies104216983dar_bies
darioles9710693darioles
darkles124011933dar_kles
dartles84014133dar_tles
datable101714233datable_
debacles1335723debacles
derailed102410403derailed
derails84216393derail_s
deranges1039973deranges
derates84028893dera_tes
derbies103016053der_bies
desirables1344213desirables
dibbles124013333d_ibbles
disable10516433disable_
disabled1248713disabled
disabler1147913disabler
disablers1255803disablers
doable93115243d_oable_
doubles103113353d_oubles
dowable13189453dowable_
drabbed13428723d_rabbed
drabber12438593d_rabber
drabbest13295663d_rabbest
drabbet12319573d_rabbet
drabbets13294823d_rabbets
drabble12238883d_rabble_
drabbled14367053d_rabbled
drably123511613d_rabl_y
drabness1135803d_rabness
drabs85119673d_rab__s
dragees9359483d_ragees
draggles1145963d_raggles
drails74716953d_rail_s
drakes114715863d_ra_kes
drapes95419653d_ra_pes
drawees11378363d_rawees
drawled12368343d_rawled
drawler11338593d_rawler
drawlers12307313d_rawlers
drawls105511393d_rawl_s
dribbles13348393dribbles
driblet103712243d_riblet
driblets11266093d_riblets
drumble12337893drumble_
drumbled14266033drumbled
dryable13237433dryable_
duals65620083du_a_l_s
ductules1155543ductules
duffles14308923du_ffles
durableness1446713durableness
dural64923893dura_l__
duramen1096903dura_men
duramens1195153duramens
durance1059113durance_
duras65727733dura___s
duratives1346223duratives
durbars1077973dur_bars
dures65635923dur___es
duresses939173duresses
durries83817353dur_ries
dutiable1137373dutiable_
duxelles1643963duxelles
dyable12308983d_yable_
dyeable1337303dyeable_
eatables10169793eatables
educable1337093educable_
enables92813123_enables
endurable1247733endurable_
errable9312183errable_
fables114921673__fables
fumbles143514413fu_mbles
furanes103214863fura_nes
furlable1335893furlable_
gables94222333__gables
garbles104016923gar_bles
grabbles13339893_grabbles
grumbles13288873grumbles
gurgles94312873gur_gles
gustables12165223gustables
hirable121612313hirable_
humbles143215803hu_mbles
hurdles113613373hur_dles
hurtles103913753hur_tles
incurables14105143incurables
jumbles183013323ju_mbles
marbles114516653mar_bles
miracles1238333miracles
morales93619403mora_les
movables15175573movables
mumbles133014433mu_mbles
muraled10410833mura_led
muralled1136423muralled
murals84016763mura_l_s
mutable11312303mutable_
notables10178243notables
nubbles113412433nu_bbles
numbles113814273nu_mbles
oracles93212423_oracles
outfables1485563outfables
parable111819773parable_
payables15166483payables
portables1337873portables
potables12179703potables
pourable1239133pourable_
purfles122511843pur_fles
purples112712833pur_ples
quibbles2134223quibbles
rabbles113517973__rabbles
rabies85226023__rabies
rales54947493__ra_les
rambles113118313__rambles
ratables10159723ratables
retables101712673retables
reusables1175223reusables
robles85321693__robles
rubbles113715113ru_bbles
rubles83921703__rubles
rulable9310533rulable_
rumbles114018393ru_mbles
sables85026693__sables
scrabbles15206283scrabbles
scrambles15146383scrambles
sparables13167163sparables
stables93219073_stables
storables1146283storables
suable83920553su_able_
surbases10310003surbases
surfable1338443surfable_
tables84524893__tables
taxables1734383taxables
thuribles1442523thuribles
trebles9311443_trebles
tumbles113816023tu_mbles
tunable92511313tunable_
turnable1037853turnable_
turntables1242263turntables
turtles72914343tur_tles
umbles103817493_u_mbles
unable83819223_unable_
unbales92914863_unbales
urares64519093_ura_res
urases63723563_ura_ses
urates65027763_ura_tes
usable84012553_usable_
variables1444673variables
vocables15145733vocables
warbles123215563war_bles
wearables14155013wearables
wirable121610963wirable_

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.406440125.6
2DLD Change Limit1461621947.29620033.2
3Display Results1941940.0633079.4
 (SQL Overall)1786911947.76523012.4
 
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.