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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

149 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
pickinesses199683(None) 
ickinesses1637181_ickinesses
cockinesses1947562cockinesses
icinesses11310072_ic_inesses
inkinesses1439422_inkinesses
kinkinesses1435872kinkinesses
luckinesses1746652luckinesses
milkinesses1786792milkinesses
packnesses1856632pack_nesses
pawkinesses2036152pawkinesses
perkinesses1748922perkinesses
peskinesses1746572peskinesses
pickiness1737622pickine_s_s
pigginesses1555612pigginesses
pinknesses1636582pink_nesses
pipinesses1448602pi_pinesses
pithinesses1637502pithinesses
pixinesses1937372pi_xinesses
pluckinesses2043992pluckinesses
pokinesses1669612p_okinesses
porkinesses1748772porkinesses
pricklinesses2143622pricklinesses
punkinesses17127222punkinesses
riskinesses1537832riskinesses
rockinesses1737362rockinesses
sicklinesses1844862sicklinesses
sicknesses1636762sick_nesses
silkinesses1557902silkinesses
spicinesses1547102spic_inesses
spikinesses1746522spi_kinesses
stickinesses1845082stickinesses
tackinesses1737252tackinesses
trickinesses1845222trickinesses
wackinesses2036652wackinesses
yuckinesses2044762yuckinesses
achinesses1539303_achinesses
airinesses102613613ai_rinesses
balkinesses1767503balkinesses
bitchinesses1943523bitchinesses
bittinesses13148263bittinesses
boskinesses17136813boskinesses
bulkinesses1786483bulkinesses
cakinesses16310613_cakinesses
corkinesses1749213corkinesses
diakineses1543693diakine_ses
dinginesses1337473dinginesses
dippinesses1635243dippinesses
dirtinesses1239883dirtinesses
ditsinesses12108763ditsinesses
ditzinesses21126213ditzinesses
dizzinesses20124023dizzinesses
dorkinesses1647663dorkinesses
duskinesses16136843duskinesses
ficklenesses2144153ficklenesses
fierinesses1439233fierinesses
filminesses1636233filminesses
finickinesses2272063finickinesses
fishinesses17107243fishinesses
flakinesses1837073flakinesses
flukinesses1836093flukinesses
forkinesses1848003forkinesses
friskinesses1944773friskinesses
funkinesses18137003funkinesses
gawkinesses1935633gawkinesses
geekinesses1635813geekinesses
giddinesses1435303giddinesses
hillinesses1458503hillinesses
hippinesses1845493hippinesses
hokinesses1758943_hokinesses
huskinesses18136533huskinesses
ickiness1436753_ickine_s_s
iffinesses1635583_iffinesses
itchinesses1644613itchinesses
jerkinesses2246053jerkinesses
jokinesses2147533_jokinesses
juicinesses2035893juic_inesses
kookinesses1435373kookinesses
lacinesses12312123lac_inesses
lankinesses1539013lankinesses
larkinesses1538993larkinesses
leakinesses1538473leakinesses
licitnesses1346413licitnesses
likenesses1449533li_kenesses
liminesses121310853li_minesses
lippinesses1535513lippinesses
miffinesses1944363miffinesses
mirinesses121512313mi_rinesses
mistinesses131310623mistinesses
murkinesses17136783murkinesses
muskinesses17127043muskinesses
nicenesses12310353nic_enesses
niftinesses1437243niftinesses
nippinesses1545063nippinesses
oilinesses101512443oi_linesses
pastinesses13911713pastinesses
patchinesses1944363patchinesses
peppinesses1435313peppinesses
pettinesses1338633pettinesses
phoninesses1636453phoninesses
pinkishnesses2243983pinkishnesses
piousnesses1348983piousnesses
pottinesses1339103pottinesses
prissinesses1355953prissinesses
prosinesses13310853prosinesses
puckishnesses2443333puckishnesses
pudginesses1545053pudginesses
puffinesses1934513puffinesses
pugginesses1545253pugginesses
pulpinesses1536003pulpinesses
puninesses121110753p_uninesses
pursinesses1338743pursinesses
pushinesses1697333pushinesses
quakinesses2436323quakinesses
quicknesses2643753quick_nesses
quirkinesses2542893quirkinesses
racinesses12313513rac_inesses
richnesses1537803ric_hnesses
riminesses121211413ri_minesses
ritzinesses2096743ritzinesses
shakinesses1837613shakinesses
sickishnesses2143663sickishnesses
sillinesses1169843sillinesses
sissinesses9118313sissinesses
sizinesses1938653si_zinesses
slicknesses1745193slick_nesses
slinkinesses1645813slinkinesses
smokinesses1736253smokinesses
snakinesses1538553snakinesses
spacinesses1538103spac_inesses
spiffinesses2043013spiffinesses
spininesses1358453spi_ninesses
spookinesses1844093spookinesses
spunkinesses1844383spunkinesses
stockinesses1844503stockinesses
sulkinesses1557723sulkinesses
talkinesses1537353talkinesses
thicknesses2043913thick_nesses
tidinesses1139223ti_dinesses
tininesses10311163ti_ninesses
tinninesses1136863tinninesses
tipsinesses1336363tipsinesses
tricksinesses1962433tricksinesses
wickednesses2243273wickednesses
wilinesses131911093wi_linesses
wimpinesses1835633wimpinesses
windinesses1557813windinesses
wirinesses131811523wi_rinesses
wispinesses1636273wispinesses
wittinesses14127483wittinesses

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 Filter1786911216330.623286823.4
2DLD Change Limit1216331497.78315628.0
3Display Results1491490.280532.1
 (SQL Overall)1786911498.68620572.3
 
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.