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

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

66 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
impracticable236177(None) 
impracticably2662071impracticably
impractical1953082impractica_l_
impractically2454362impractically
practicable1953832__practicable
practicably2254303__practicably
impartible1644364imp_arti__ble
impeachable2253924impeac__hable
impeccable2044524imp_ec__cable
imperceivable2461964imperceivable
implacable1844614impla___cable
implantable1753334implant__able
impracticality2561414impracticality
ineradicable1754284inera_dicable
intractable1557364intract__able
irradicable16184074i_rra_dicable
practical1548844__practica_l_
practically20410444__practically
practicals1645544__practica_ls
unpractical1753764unpractica_l_
amerciable1653745amer_c_i_able
amortizable2452375amor__tizable
appreciable1953845apprec_i_able
compactible2153655comp_acti__ble
depreciable1854555deprec_i_able
distractable1753605distract__able
distractible1763545distracti__ble
embraceable1952085embrac__eable
emphatically2456435empha_tically
emptiable1544845emp___ti_able
eradicable1545635__era_dicable
extractable2254155extract__able
imaginable1544295im__a_ginable
immedicable2053215im__medicable
immitigable1851955im__mitigable
impactive1845285imp_acti___ve
impalpable1843365imp_a__lpable
impartial1345185imp_arti_a_l_
impartially1853815imp_arti_ally
impartibly1953835imp_arti__bly
impassable1645255imp_a__ssable
impassible1655205imp_assi__ble
impeccably2353935imp_ec__cably
impenetrable1852375impenet_rable
implacably2153975impla___cably
implausible1752575implausi__ble
impolitical1753335impolitica_l_
impolitically2254615impolitically
importable1646555imp_ort__able
impregnable1853485impr__egnable
impressible1755565impressi__ble
impressionable2062375impressionable
improbable1844835impr___obable
improvable1945255impr___ovable
imputable1546685imp__ut__able
ineradicably2054715inera_dicably
insatiable12107765i_nsa_ti_able
intractably1856665intract__ably
irradicably19144185i_rra_dicably
machinable1944265_m__achinable
nonpractical1854235nonpractica_l_
practice1438735__practic___e
predicable1747195__pr_edicable
retractable1545125retract__able
tractable1338515__tract__able
trafficable2172005__trafficable

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 Filter1786911247900.393454684.5
2DLD Change Limit124790668.51314658.8
3Display Results66660.0461434.8
 (SQL Overall)178691668.95219961.0
 
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.