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

116 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
unactable1331005(None) 
enactable1338491enactable
actable11313472__actable
exactable2046432exactable
tractable1338512tractable
unamiable1348472unamiable
uncapable1547782uncapable
undatable1238982undatable
uneatable11311692uneatable
unstable10313762un_stable
abatable1238023aba_table
adaptable1444613adaptable
beatable121612243bea_table
boatable121610263boa_table
cartable121314093_cartable
castable121613973_castable
chantable1636893chantable
chartable1636833chartable
coachable1846303coachable
danceable1445303danceable
datable101714233_da_table
draftable1575563draftable
eatable91717603_ea_table
ejectable20136573ejectable
electable13149623electable
erectable131210093erectable
faceable15108493_faceable
gnawable1435683gna_wable
grantable1257293grantable
hackable1937473_hackable
hatable121713963_ha_table
heatable131612043hea_table
huntable1338093hun__table
inarable10313133ina_rable
incapable1547563incapable
incitable13310433incitable
indictable1547493indictable
injectable2147003injectable
instable10313203in_stable
intractable1557363intractable
knittable1544243knittable
leachable16136443leachable
locatable1345573locatable
munchable1844943mun_chable
namable11312343_na_mable
nameable1238863_nameable
nestable101613673_nestable
nettable101610243_nettable
notable92114903_n_otable
packable1838633_packable
peaceable1548253peaceable
placable14169243plac_able
placeable1536913placeable
plantable1337273plantable
poachable1846243poachable
ratable91717553_ra_table
reachable16129653reachable
stackable1735993stackable
statable10310703sta_table
tastable101511973_tastable
teachable16137603teachable
tenantable1244183tenantable
traceable1338323traceable
trackable1736743trackable
tractably1646243tractably
unable83819223un___able
unacceptable20103603unacceptable
unadaptable1653913unadaptable
unadoptable1653533unadoptable
unalterable1345773unalterable
unamenable1446943unamenable
unarguable1344833unarguable
unbeatable1447833unbeatable
uncatchable2053883uncatchable
uncurable13710073uncurable
undanceable1654403undanceable
undauntable1474213undauntable
undoable1139053un_doable
unelectable1546753unelectable
unexcitable2245063unexcitable
unflyable1744633unflyable
unhirable1447643unhirable
unifiable1447343unifiable
unlikable1546773unlikable
unlivable1447603unlivable
unlovable1446363unlovable
unmatchable2063513unmatchable
unmixable2045863unmixable
unmovable1645963unmovable
unnamable1356623unnamable
unnameable1445503unnameable
unpalatable1544793unpalatable
unpassable1446133unpassable
unpliable1347813unpliable
unreachable1846093unreachable
unridable1248293unridable
unsalable1148993unsalable
unsayable1447223unsayable
unscalable1446353unscalable
unscramble1652983unscramble
unseeable1149453unseeable
unsociable1447283unsociable
unstabler1145623un_stabler
unstably1339493un_stably
unsuitable1247573unsuitable
untamable1347843untamable
unteachable1845743unteachable
untenable11410503untenable
untestable1248823untestable
untraceable1546853untraceable
untunable1147833untunable
unusable1038953un_usable
unviable1338703un_viable
unwatchable2153193unwatchable
vacatable1644643_vacatable
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.423422437.4
2DLD Change Limit1486411167.31020333.9
3Display Results1161160.0502320.0
 (SQL Overall)1786911167.78322959.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.