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

64 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
pregnable145669(None) 
impregnable1853482impregnable
previable1647532previable
prunable1237842pr_unable
amenable1238863ame_nable
arguable1135903ar_guable
breakable1746163breakable
cleanable1345203cleanable
creatable1339563creatable
drainable1237583drainable
enable83318483__e_nable
erectable131210093erectable
freezable2345093freezable
gleanable1244083gleanable
impregnably2153093impregnably
lienable10188693lie_nable
openable1247013ope_nable
pardonable1544023pardonable
pawnable1535983p_awnable
peccable1648123p_eccable
peelable1238553p_eelable
permeable1556823permeable
personable1467073personable
perusable1347453perusable
pettable121710713p_ettable
pleadable1445513pleadable
preamble1436383pre_amble
preanal9310713preana_l_
predicable1747193predicable
preferable1746723preferable
pregame1239553preg_a_me
pregnancy1744063pregnancy
pregnant1149883pregna_nt
pregnantly1643723pregnantly
prehandle1544533prehandle
prename11412643pre_na_me
presale9416353pre_sa_le
presentable1546033presentable
presumable1645203presumable
preventable1844983preventable
priceable1546823priceable
printable1338203printable
probable1439053pr_obable
provable1539093pr_ovable
purgeable1444413purgeable
readable11313163_readable
reapable12311393_reapable
reefable1339533_reefable
reelable10311593_reelable
refinable1438623_refinable
regale74821453_reg_a_le
regnal74812933_regna_l_
regulable1246513_regulable
reliable10313073_reliable
rentable101716333_rentable
restable101618443_restable
retable91820403_re_table
reusable10811273_reusable
ruinable1039263_ruinable
screenable1443703screenable
spreadable1544423spreadable
tenable93214493_te_nable
trainable1138943trainable
treatable1139323treatable

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 Limit148641646.76621968.8
3Display Results64640.0302133.3
 (SQL Overall)178691647.21924752.9
 
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.