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

173 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
valuable133686(None) 
evaluable1444231evaluable
valuables1442971valuables
valuably1644711valuably
callable12310752callable
invaluable1545072invaluable
palpable1448032palpable
salable91415462sal_able
saleable10312022saleable
salvable1338402salvable
talkable1437192talkable
valuate102512732valua_te
variable13310062variable
voluble1244502volu_ble
walkable1736062walkable
abubble1044523_abubble
abusable1236373_abusable
actable11313473_actable
addable11218843_addable
affable15117403_affable
alible8311973_al_ible
alliable1038433alliable
amiable11312033_amiable
amusable1237143_amusable
arable81821003_a_rable
arguable1135903arguable
available1444903available
avowable1635453avowable
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
bauble103813213ba_u_ble
billable12179503billable
blamable1436693blamable
calculable1643643calculable
capable13313363ca_pable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
castable121613973castable
causable1239973causable
clubable1436093_clubable
culpable1436283culpable
damnable1347593damnable
datable101714233da_table
dateable1149443dateable
eatable91717603ea_table
equable1849253_equable
evadable1436363eva_dable
evaluate11287793evalua_te
evolvable1743383evolvable
faceable15108493faceable
fadable13310463fa_dable
fallible1355363fallible
farmable1538203farmable
fellable13179133fellable
fileable13179223fileable
fillable13179563fillable
filmable15157133filmable
flyable15307123_flyable
foldable1437133foldable
gainable1138933gainable
gelable101710733gel_able
gullable1136463gullable
hackable1937473hackable
hangable1438203hangable
hatable121713963ha_table
hateable1339373hateable
healable131610173heal_able
helpable1536603helpable
holdable1437073holdable
invaluably1854123invaluably
issuable1046873issuable
jailable1737143jailable
jammable2144513jammable
killable14168133killable
lapsable12117383lapsable
laudable1137893laudable
liable81415813__liable
mailable1239623mailable
makable15510203ma_kable
makeable1637253makeable
malleable1376073malleable
mappable1635923mappable
maskable1638003maskable
meltable12310473meltable
millable121710133millable
moldable1337103moldable
namable11312333na_mable
nameable1238863nameable
packable1838633packable
palatable1346373palatable
palpably1745363palpably
parable111819773pa_rable
parsable12311693parsable
passable12310623passable
pawnable1535983pawnable
payable141711323pa_yable
placable14169243placable
playable15137923playable
pliable111610323_pliable
radiable11611303radiable
raisable10311643raisable
ratable91717553ra_table
rateable10311443rateable
reliable10313073reliable
rulable9310533rul_able
sailable10310563sailable
salably121610743sal_ably
saleably1338213saleably
salvably1645443salvably
sandable111612823sandable
satiable10310733satiable
saturable1146633saturable
savable121711863sa_vable
saveable1339003saveable
sayable121411613sa_yable
scalable121710233scal_able
sealable101512693seal_able
sellable101711823sellable
slakable14177553slakable
slayable13157563slayable
soluble966103solu_ble
solvable1337473solvable
spallable1345833spallable
suable83920553__suable
syllable13177773syllable
tabulable1344043tabulable
takable13310193ta_kable
takeable1437463takeable
tamable11312843ta_mable
tameable1238603tameable
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
tastable101511973tastable
taxable1639073ta_xable
tellable10169773tellable
tillable10159753tillable
tiltable10159013tiltable
vacatable1644643vacatable
vacuole1245373vacu_ole
valance1269253val_ance
valiance1397383valiance
vallate103016563valla_te
valuated12239203valuated
valuates112811193valuates
valuator1196723valuator
value85719093valu___e
valval12398863valva_l_
valvate133710813valva_te
valvule1343663val_vule
vaporable1645543vaporable
variables1444673variables
variably1637433variably
vendable14159693vendable
viable111613773v__iable
viewable1635223viewable
violable1337543violable
vitiable1337503vitiable
vocable14189673v_ocable
voidable1466853voidable
volubly1543553volu_bly
votable122111373v_otable
voteable1347213voteable
wadable13310233wa_dable
wadeable1437443wadeable
washable16138043washable
wastable131410453wastable
waxable1937673wa_xable
weldable1436863weldable
willable13168683willable

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 Limit1461621739.31315694.4
3Display Results1731730.0762276.3
 (SQL Overall)1786911739.54518720.9
 
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.