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

209 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
servable1331008(None) 
derivable1548062derivable
errable9312182_errable
observable1743332observable
reservable1546362reservable
salvable1338402salvable
savable121711862s_avable
sealable101512692sealable
seeable91113942se_eable
seisable10311372seisable
seizable1938722seizable
sellable101711822sellable
sendable111612042sendable
serval93913412serva_l_
servals103410742serva_ls
servile10310642serv_ile
sewable121911172se_wable
shavable16177272shavable
solvable1337472solvable
sorbable1239302sorbable
sortable10312482sortable
surfable1338442surfable
arable81821003_ar_able
averrable14105413averrable
avertable14117343avertable
barrable1249243barrable
bearable121512363bearable
beatable121612243beatable
beddable14166923beddable
bendable131510853bendable
burnable1237263burnable
cartable121314093cartable
cleavable1644473cleavable
crevalle1346163crevalle
curable112414513cur_able
curbable1447663curbable
deniable11312083deniable
drivable1438023drivable
dryable13237433_dryable
durable102312723dur_able
eatable91717603_eatable
effable15106673_effable
enable83318483_e_nable
enviable1337853_enviable
equable1849253_equable
erasable10511043_erasable
erodable1139203_erodable
eyeable1239063_eyeable
farmable1538203farmable
feedable1437673feedable
fellable13179133fellable
fireable131710223fireable
fordable1439593fordable
formable1539503formable
friable122612563_friable
fryable15277463_fryable
furlable1335893furlable
gelable101710733ge_lable
getable101712553ge_table
gettable11178133gettable
healable131610173healable
hearable131611603hearable
heatable131612043heatable
helpable1536603helpable
heritable1439453heritable
hewable15177823he_wable
hirable121612313hir_able
hireable13139083hireable
inerrable11410153inerrable
keepable1635323keepable
learnable1145563learnable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
livable122010323_livable
lovable12179553_lovable
meltable12310473meltable
mendable131510583mendable
miserable1349653miser_able
movable14189433_movable
nervate1039523nerva_te
nervule1044943nerv_ule
nestable101613673nestable
nettable101610243nettable
observables1852003observables
observably2052643observably
operable12410323oper_able
overable13513573over_able
parable111819773par_able
parsable12311693parsable
peccable1648123peccable
peelable1238553peelable
percale11314093perca_le
permeable1556823permeable
perusable1347453perusable
pervade1337023perva_de
pettable121710713pettable
portable12313203portable
preservable1844163preservable
previable1647533previable
provable1539093provable
readable11313163readable
reapable12311393reapable
reefable1339533reefable
reelable10311593reelable
reliable10313073reliable
relivable1438513relivable
removable1646923removable
rentable101716333rentable
restable101618443restable
retable91820403re_table
reusable10811273reusable
revivable1736863revivable
sable74732163s___able
sailable10310563sailable
salable91415463s_alable
saleable10312023saleable
salvably1645443salvably
sandable111612823sandable
satiable10310733satiable
saveable1339003saveable
sayable121411613s_ayable
scalable121710233scalable
scrabble14196993scrabble
scramble14177253scramble
screwable1644843screwable
scribble14175433scribble
scrutable1346043scrutable
searchable1744143searchable
securable1347773securable
selvage1136553selva_ge
semblable1544843semblable
sensible1037853sensible
separable1348673separable
serail64222673ser_ail_
serails73318363ser_ails
seral56336383ser_a_l_
serape84818413ser_a_pe
serdab937833serdab__
serdabs1035323serdab_s
serfage1138403serfa_ge
serial64625863seria_l_
serially11912843serially
serials73919743seria_ls
seriate73722473seria_te
serrate73017543serra_te
servant10313623serva_nt
servants1137993servants
serve85425963serv___e
service1239083serv_ice
serviceable1852403serviceable
severable1438543severable
shakable17177683shakable
shamable15168803shamable
shapable15197803shapable
sharable131910693sharable
shareable1436733shareable
shedable1437423shedable
sheddable1643693sheddable
showable1636583showable
singable11159543singable
sinkable14178413sinkable
sizable1839893s_izable
sizeable1937113sizeable
skiable1338883s_kiable
slakable14177553slakable
slayable13157563slayable
slidable1137953slidable
smokable1636223smokable
sociable1239503sociable
sortably1338803sortably
sowable121610753s_owable
sparable121611983sparable
spareable1337263spareable
speakable1745373speakable
spendable1446463spendable
stable83921643s__table
statable10310703statable
stealable1136573stealable
steerable1146913steerable
stewable1337133stewable
stonable1039843stonable
storable10310733storable
stowable1337613stowable
suable83920553s__uable
suitable10310893suitable
summable1436903summable
superable13312483super_able
survivable1842953survivable
swayable16135533swayable
syllable13177773syllable
tearable101512673tearable
teasable101511173teasable
tellable10169773tellable
tenable93214493te_nable
terrible1046643terrible
testable101412623testable
triable92515393_triable
turnable1037853turnable
useable9911063use__able
variable13310063variable
vendable14159693vendable
veritable1448743veritable
vernacle1345583vernacle
wearable131510553wearable
weldable1436863weldable
wettable13148043wettable
wirable121610963wir_able
workable1737093workable

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.423422437.4
2DLD Change Limit1461622096.97020970.2
3Display Results2092090.0932247.3
 (SQL Overall)1786912097.48623870.0
 
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.