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

123 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
gullable113646(None) 
gullably1444791gullably
gullible1144061gullible
billable12179502billable
callable12310752callable
culpable1436282culpable
fellable13179132fellable
fillable13179562fillable
furlable1335892furlable
gelable101710732g_elable
guidable1236202guidable
gullibly1443472gullibly
gustable11138202gustable
killable14168132killable
millable121710132millable
quellable2043672quellable
rulable9310532ru_lable
sellable101711822sellable
sulliable1145912sulliable
syllable13177772syllable
tellable10169772tellable
tillable10159752tillable
willable13168682willable
alliable1038433alliable
bailable1238583bailable
boilable1237793boilable
buffable1844393buffable
buildable1443523buildable
bullace113410673bulla_ce
bullae83416163bulla__e
bullate93415073bulla_te
burnable1237263burnable
buyable1437493bu_yable
clubable1436093clubable
culpably1744313culpably
curable112414513cu_rable
curbable1447663curbable
cuttable1247953cuttable
drillable1245133drillable
dupable12238383du_pable
durable102312723du_rable
dutiable1137373dutiable
exilable1737203exilable
fallible1355363fallible
fileable13179223fileable
filmable15157133filmable
flyable15307123_flyable
foilable1338063foilable
foldable1437133foldable
gable85325523g___able
gainable1138933gainable
gallate83417123galla_te
gaugeable1342983gaugeable
getable101712553g_etable
gettable11178133gettable
giftable1465893giftable
giveable14155753giveable
gnawable1435683gnawable
gradable1238823gradable
grazable2036223grazable
growable1435623growable
guessable1243733guessable
gunwale1134733gunwa_le
gustables12165223gustables
healable131610173healable
helpable1536603helpable
holdable1437073holdable
huggable1543333huggable
hummable1744583hummable
huntable1338093huntable
isolable1038793isolable
jailable1737143jailable
jumpable2143953jumpable
liable81415813__liable
lullabied1242363lullabied
lullabies1143893lullabies
lullaby1243363lullab_y
mailable1239623mailable
malleable1376073malleable
meltable12310473meltable
moldable1337103moldable
mutable11312303mu_table
outfable1378813outfable
palpable1448033palpable
peelable1238553peelable
pliable111610323_pliable
quotable1936493quotable
reelable10311593reelable
regulable1246513regu_lable
reliable10313073reliable
ruinable1039263ruinable
rustable101511353rustable
sailable10310563sailable
salable91415463_salable
saleable10312023saleable
salvable1338403salvable
scalable121710233scalable
sealable101512693sealable
solvable1337473solvable
spallable1345833spallable
spillable1345353spillable
suable83920553su__able
suitable10310893suitable
sullage859913sulla_ge
summable1436903summable
surfable1338443surfable
syllabled15163813syllabled
syllables14144753syllables
talkable1437193talkable
tiltable10159013tiltable
tubbable1134683tubbable
tullibee1044333tullibee
tunable92511313tu_nable
tuneable1038913tuneable
turnable1037853turnable
ullage739043_ulla_ge
unable83819223_u_nable
usable84012553_u_sable
useable9911063_useable
valuable1336863valuable
violable1337543violable
walkable1736063walkable
weldable1436863weldable

Search took 9 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.1731032896.0
2DLD Change Limit1461621237.84318636.0
3Display Results1231230.0462673.9
 (SQL Overall)1786911238.06222164.6
 
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.