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

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

56 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
childishness215260(None) 
childishnesses2352562childishnesses
caddishness1843413c_addishness
childlessness1963873childlessness
childlikeness2361153childlikeness
chilliness1555313chilli__ness
churlishness2052513churlishness
cliquishness2652143cliquishness
cloddishness1952503cloddishness
coltishness1645043c_oltishness
cultishness1644333c_ultishness
hellishness1744113_hellishness
thievishness2192103thievishness
blimpishness2172074blimpishness
bluishness1544594__bluishness
bullishness1643954_bullishness
childish1744394childish____
childishly2251844childish__ly
childless1543814child___less
chillness1455374chil___lness
clannishness1752814clannishness
clownishness2052284clownishness
devilishness1962384devil_ishness
dollishness1544014_dollishness
doltishness1544214_doltishness
faddishness1943244_faddishness
faintishness1863064faintishness
fiendishness1952334fiendishness
folkishness2143834_folkishness
foolishness1744494fool_ishness
ghoulishness1952344ghoulishness
girlishness1573654_girlishness
hawkishness2443274_hawkishness
hilliness1248924_hilli__ness
hoggishness1983584_hoggishness
impishness1744124__impishness
modishness1644554__modishness
mulishness1544544_mul_ishness
owlishness1644164_owl_ishness
piggishness1873144_piggishness
pinkishness2043834_pinkishness
priggishness19112284priggishness
prudishness1743574_prudishness
qualmishness2652174qualmishness
reddishness1643434_reddishness
selfishness1743814_selfishness
sheepishness2052934sheepishness
shrewishness2152184shrewishness
sickishness2043654_sickishness
skittishness1952414skittishness
sniffishness2152194sniffishness
stylishness1743444styl_ishness
swinishness1743574swi_nishness
trickishness2152524trickishness
wimpishness2143214_wimpishness
wolfishness2043734_wolfishness

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 Filter1786911247900.406440125.6
2DLD Change Limit124790566.03320684.6
3Display Results56560.0301866.7
 (SQL Overall)178691566.46927622.7
 
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.