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

122 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
unusable103895(None) 
abusable1236372abusable
amusable1237142amusable
causable1239972causable
nonusable1146762nonusable
reusable10811272reusable
unable83819222un__able
uncurable13710072uncurable
undoable1139052undoable
unstable10313762unstable
untunable1147832untunable
unviable1338702unviable
usable84012552__usable
accusable1544873accusable
arousable1145573arousable
buyable1437493_buyable
closable12168003closable
clubable1436093clubable
crushable1645263crushable
curable112414513_curable
disable10516433_disable
dupable12238383_dupable
durable102312723_durable
educable1337093educable
enable83318483en__able
endurable1247733endurable
enviable1337853enviable
equable1849253equ_able
erasable10511043erasable
excusable2044373excusable
flushable1743573flushable
focusable1644103focusable
fusible1237023_fusible
gnawable1435683gnawable
guessable1243733guessable
gustable11138203_gustable
huntable1338093hun_table
inarable10313133inarable
incunable13108743incunable
incurable131010773incurable
infusible1445923infusible
injurable18117413injurable
instable10313203instable
insurable111011093insurable
inviable1338523inviable
issuable1046873issuable
kissable1436853kissable
knowable1745043knowable
lapsable12117383lapsable
laudable1137893laudable
leasable101510133leasable
losable91910953_losable
missable12311533missable
munchable1844943munchable
mutable11312303_mutable
namable11312343_namable
nestable101613673_nestable
notable92114903_notable
nubble103813713_nu_bble
parsable12311693parsable
passable12310633passable
perusable1347453perusable
posable112212783_posable
pourable1239133pourable
prunable1237843prunable
punishable1743283punishable
pursuable1344693pursuable
raisable10311643raisable
refusable1476683refusable
reusables1175223reusables
rinsable10310043rinsable
rulable9310533_rulable
rustable101511363_rustable
sable74732163___sable
seisable10311373seisable
suable83920553_su_able
teasable101511173teasable
tenurable1147423tenurable
trustable1147123trustable
tunable92511313_tunable
tuneable1038913tun_eable
unactable13310053unactable
unamiable1348473unamiable
unbale83616403un_ba_le
unburnable1444573unburnable
uncapable1547783uncapable
uncrushable1853573uncrushable
uncurably1697793uncurably
undatable1238983undatable
undouble1145443undouble
uneatable11311693uneatable
unedible1146413unedible
uneducable1545783uneducable
unflyable1744633unflyable
unguessable1453153unguessable
unhirable1447643unhirable
unifiable1447343unifiable
unlikable1546773unlikable
unlivable1447603unlivable
unlovable1446363unlovable
unmixable2045863unmixable
unmovable1645963unmovable
unnamable1356623unnamable
unpassable1446133unpassable
unpliable1347813unpliable
unridable1248293unridable
unsaddle1044753un_saddle
unsafe9310693un_sa_fe
unsalable1148993unsalable
unsayable1447223unsayable
unseeable1149453unseeable
unstabler1145623unstabler
unstably1339493unstably
unsubtle1043873unsubtle
unsuitable1247573unsuitable
untamable1347843untamable
untenable11410503untenable
untestable1248823untestable
unusual743943unusual_
unusually1243333unusually
usably11288983__usably
useable9911063u_seable

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.420425454.8
2DLD Change Limit1461621227.23620199.3
3Display Results1221220.0432837.2
 (SQL Overall)1786911227.69923209.6
 
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.