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

58 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
amassable134606(None) 
amusable1237142am_usable
classable1347142classable
impassable1645252impassable
maskable1638002_maskable
missable12311532_missable
passable12310632_passable
abatable1238023aba_table
abusable1236373a_busable
accusable1544873accusable
adaptable1444613adaptable
admissible1552623admissible
advisable1544573advisable
alarmable1345013alarmable
amenable1238863am_enable
amendable1446053amendable
amiable11312033am__iable
amicable1438433am_icable
apposable1545603apposable
arousable1145573arousable
assayable1443643assayable
assessable1243413assessable
available1444903available
awardable1543953awardable
cascable141510623_cascable
cashable15159793_cashable
castable121613973_castable
causable1239973_causable
chaseable1646343chaseable
compassable1954213compassable
crossable1347073crossable
embossable1652403embossable
erasable10511043era_sable
graspable1444873graspable
guessable1243733guessable
imageable1445443imageable
impassably1954353impassably
impassible1655203impassible
imposable1546443imposable
kissable1436853_kissable
lapsable12117383_lapsable
leasable101510133lea_sable
mailable1239623_mailable
makable15510203_ma_kable
makeable1637253_makeable
mappable1635923_mappable
massacre1244743_massacre
massage1039893_massa_ge
omissible1344093omissible
parsable12311693_parsable
passably1537253_passably
passible1237693_passible
raisable10311643_raisable
tastable101511973_tastable
teasable101511173tea_sable
unpassable1446133unpassable
washable16138043_washable
wastable131410453_wastable

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641586.84321721.6
3Display Results58580.0331757.6
 (SQL Overall)178691587.03225411.1
 
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.