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 “buffable” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
buffable184439(None) 
bluffable1942061bluffable
affable15117402_affable
buffalo1553722buffa_lo
burnable1237262burnable
buyable1437492bu_yable
effable15106672_effable
outfable1378812outfable
surfable1338442surfable
abusable1236373abu_sable
affably1855183_affably
baffle14399873baff__le
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
bearable121512363bearable
beatable121612243beatable
beddable14166923beddable
bendable131510853bendable
biddable14165673biddable
billable12179503billable
bindable13169623bindable
bitable11312203b_itable
biteable1237933biteable
blamable1436693blamable
boatable121610263boatable
boilable1237793boilable
bombable1336263bombable
bondable13169273bondable
bookable16127003bookable
bootable12179223bootable
boundable1444843boundable
bribable1137223bribable
bubale104014623bu_ba_le
bubble94016593bu__bble
buffaloed1841543buffaloed
buffaloes1742093buffaloes
buffalos1642863buffalos
buildable1443523buildable
bumble124216893bu__mble
burble104617703bu__rble
burnables1344003burnables
culpable1436283culpable
curable112414513cu_rable
curbable1447663curbable
cuttable1247953cuttable
duffle13368533duff__le
dupable12238383du_pable
durable102312723du_rable
dutiable1137373dutiable
fable105824753___fable
furlable1335893furlable
giftable1465893giftable
guidable1236203guidable
gullable1136463gullable
gustable11138203gustable
huggable1543333huggable
hummable1744583hummable
huntable1338093huntable
ineffable17105793ineffable
jumpable2143953jumpable
liftable1376863liftable
muffle14339643muff__le
mutable11312303mu_table
outfabled1595093outfabled
outfables1485563outfables
puffball1841983puffball
quotable1936493quotable
reefable1339533reefable
ruffle124111673ruff__le
ruinable1039263ruinable
rulable9310533ru_lable
rustable101511353rustable
sniffable1743773sniffable
suable83920553su__able
sufferable1843323sufferable
suitable10310893suitable
summable1436903summable
tubbable1134683tubbable
tunable92511313tu_nable
tuneable1038913tuneable
turnable1037853turnable
unable83819223_u_nable
usable84012553_u_sable
useable9911063_useable

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.1731032896.0
2DLD Change Limit146162869.37315593.9
3Display Results86860.0801075.0
 (SQL Overall)178691869.62618563.4
 
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.