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

76 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
pitiableness165552(None) 
pitiablenesses1855062pitiablenesses
pliableness1546602p_liableness
potableness1547192pot_ableness
amiableness1547163_amiableness
enviableness1756993enviableness
estimableness1754753estimableness
likableness1755333li_kableness
livableness1645913li_vableness
notableness1347623not_ableness
pitifulness1665483pitiful_ness
provableness1955503provableness
reliableness1457133reliableness
sizableness2265593si_zableness
sociableness1655753sociableness
stableness1248823_st_ableness
suitableness1456303suit_ableness
variableness1756433variableness
violableness1754883violableness
visibleness1654813visi_bleness
admirableness1855144admirableness
adorableness1556044adorableness
advisableness1954414advisableness
amicableness1856164amicableness
availableness1854254availableness
capableness1745884_capableness
citizeness21124654citi__zeness
culpableness1853964culpableness
curableness1547314_curableness
damnableness1755244damnableness
desirableness1666954desirableness
durableness1446714_durableness
edibleness1345294_edi_bleness
equableness22146124_equableness
equitableness24105474equitableness
excitableness2455394excitableness
futileness1346134futi__leness
habitableness2054814habitableness
ignobleness1453444_ignobleness
inimitableness1864994inimitableness
initialness1155734initia_l_ness
insatiableness1655034insatiableness
irritableness1576134irritableness
laudableness1554734laudableness
littleness1045024lit__tleness
losableness1346034_losableness
lovableness1645594_lovableness
miserableness17145754miserableness
movableness1855734_movableness
nimbleness1445594__nimbleness
palatableness1754644palatableness
paleness10312984p___a_leness
peaceableness1955284peaceableness
petiteness1248494peti__teness
pitchblendes226794pitchblendes
pitiable1238294pitiabl__e__
pitiless10127334piti__l__ess
pitilessness1474524pitilessness
pliablenesses1756074p_liablenesses
potablenesses1746504pot_ablenesses
practicableness2362704practicableness
profitableness2173814profitableness
readableness1576264readableness
staleness9310784_st_a_leness
tableless1145024__t_ableless
tenableness1347394_tenableness
thinkableness2253324thinkableness
tunableness1345944_tunableness
unstableness1457124unstableness
usableness1246504__usableness
valuableness1754784valuableness
verifiableness2283324verifiableness
veritableness1856514veritableness
vitalness1245414vit_a_l_ness
voidableness1854944voidableness
workableness2154394workableness

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790766.81318316.5
3Display Results76760.0461652.2
 (SQL Overall)178691766.99925530.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.