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 “impropernesses” 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
impropernesses2010147(None) 
improperness1851732improperne_s_s
propernesses1645012__propernesses
dappernesses1743244dap__pernesses
improprieties19142794improp_rieties
impurenesses16164434imp_ure_nesses
morosenesses1446864_morose_nesses
pronenesses1379264__prone_nesses
properness1445924__properne_s_s
amorousnesses1547815amoro_usnesses
amplenesses1585705amp__le_nesses
brokennesses1843305__brokennesses
composednesses2152285comp_osednesses
depravednesses2152375depravednesses
dopeynesses1744025___dopeynesses
forevernesses1952875_forevernesses
frozennesses2443225__frozennesses
governesses1546725___governesses
immensenesses1762995immense_nesses
imperfectnesses2461535imperfectnesses
imperiousnesses1955485imperiousnesses
impishnesses1944295imp__ishnesses
implicitnesses2061815implicitnesses
impolitenesses1853955impolitenesses
impoverishes2251395imp_over_ishes
imprecisenesses2161865imprecisenesses
impresses1338215im___p_r_esses
inexpertnesses2362415i_nexpertnesses
ingrownnesses1751985ingro_wnnesses
innernesses1146735i___nnernesses
intrepidnesses1751885intrepidnesses
invernesses1447035i___nvernesses
iratenesses11411445i__rate_nesses
irksomenesses1953195irksome_nesses
ironnesses1047835i__ro__nnesses
limbernesses1643155lim___bernesses
malapertnesses1881385_malapertnesses
markednesses1944185_mar_kednesses
meagernesses1544445_m_eagernesses
modernnesses1543865_m__odernnesses
mopinesses14139125_m__op_inesses
morenesses12811395_m__ore_nesses
murderesses1443105_mur_der_esses
opennesses1246315____opennesses
operosenesses1575325operose_nesses
paperinesses1646055__p_aperinesses
pepperinesses1653275__pepperinesses
poornesses1236805__p_o_ornesses
porteresses1345525__porter_esses
preppinesses1544885__preppinesses
primenesses1548995__prime_nesses
procuresses1543815__procur_esses
progresses1347495__pro_gr_esses
promptnesses1843635__promptnesses
prophetesses1952445__prophetesses
prosinesses13310855__pro_sinesses
proudnesses1447505__pro_udnesses
ripenesses12310375___ripe_nesses
ropinesses121311025___rop_inesses
simplenesses1645625simp__le_nesses
sobernesses1346595___sobernesses
sprucenesses1694615_spruce_nesses
supremenesses1753175supreme_nesses
timorousnesses1655695timoro_usnesses
unripenesses1446015_unripe_nesses
uprootednesses1752345_uprootednesses

Search took 7 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 Filter178691950240.360496363.9
2DLD Change Limit95024666.39014870.7
3Display Results66660.0501320.0
 (SQL Overall)178691666.80026278.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.