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

82 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
stinginess114595(None) 
stringiness1245261stringiness
dinginess1137822_dinginess
shininess1237332shin_iness
skinniness1443312skinniness
slanginess1146272slanginess
slinkiness1445152slinkiness
spininess1137962spin_iness
sponginess1344592sponginess
springiness1444622springiness
staginess1038752st_aginess
stickiness1635902stickiness
stingiest10209772stingi_est
stinginesses1375962stinginesses
stingless1046462sting_less
stodginess1243892stodginess
stoniness938342ston_iness
tanginess10239282_tanginess
tininess8310632_tin_iness
tinniness936092_tinniness
brininess1138203brin_iness
daintiness1145963daintiness
flintiness1345893flintiness
inkiness1238693__inkiness
kingliness1543953_kingliness
kinkiness1235763_kinkiness
lastingness1244003lasting_ness
manginess122010413_manginess
pigginess1375453_pigginess
raininess949273rain_iness
ranginess101610213_ranginess
saintliness1144153saintliness
sandiness102111713s_andiness
scantiness1236873scantiness
shagginess1543933shagginess
shiftiness1644793shiftiness
silkiness1337253s_ilkiness
silliness9510363s_illiness
singleness1145733s_ingleness
sissiness8217963s_issiness
siziness1737423s_i_ziness
skimpiness1842863skimpiness
sliminess1137423sli_miness
smudginess1442873smudginess
sniffiness1643753sniffiness
sogginess1136183s_ogginess
spiciness1347053spi_ciness
spiffiness1842983spiffiness
spikiness1536313spi_kiness
spunkiness1644173spunkiness
stanines85115673stan_ine_s
steadiness1146703steadiness
steaminess1236773steaminess
steeliness1046793steeliness
stibines1038153sti_bine_s
stiffness1543553sti_ffness
stillness936103sti_llness
stingarees1143163stingarees
stingers94012743sting__ers
stingier9279123stingi_e_r
stinging103213453stingin__g
stingingly1544093stingingly
stinkiest13198463stinki_est
stockiness1645243stockiness
storminess1245213storminess
strangeness1246093strangeness
stringiest11197593stringi_est
stringinesses14124533stringinesses
stringings1245233stringin_gs
stringless1145353string_less
stuffiness1643683stuffiness
sturdiness1144843sturdiness
sunniness9247943s_unniness
swankiness1744253swankiness
swingiest13207573swingi_est
swingingest1651983swingingest
swingings14275053swingin_gs
thingness1354893thing_ness
tidiness938793_ti_diness
tipsiness1135703_tipsiness
whininess1535123whin_iness
windiness1337373_windiness

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 Filter1786911406030.1701051123.5
2DLD Change Limit140603828.65616243.4
3Display Results82820.0461782.6
 (SQL Overall)178691828.87220141.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.