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

191 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
fanciness143767(None) 
fanciless1444601fanciless
bandiness122310242bandiness
canniness1138642canniness
chanciness1745122chanciness
fanciers13358082fanci_ers
fancies124018782fanci_e_s
fanciest133612712fanci_est
fancinesses1638142fancinesses
fanzines2036912fanzine_s
fascines13310142fascine_s
fattiness12239372fattiness
funkiness16226872funkiness
funniness12256532funniness
handiness132110932handiness
laciness102112552la_ciness
lankiness1338052lankiness
manginess122010412manginess
manliness111310122manliness
raciness102413452ra_ciness
rancidness1344222rancidness
randiness102511442randiness
ranginess101610212ranginess
sandiness102111712sandiness
sauciness1138042sauciness
tanginess10239282tanginess
zaniness1738662zan_iness
achiness1339703_achiness
acidness1136723_a_cidness
airiness8412223_airiness
ancients1098973_ancients
ancones93116343_ancone_s
ancress978613_anc_ress
angriness1036463_angriness
antsiness937853_antsiness
archness1337513_archness
artiness81615423_artiness
ashiness1138963_ashiness
bagginess1355953bagginess
balkiness1556903balkiness
balminess1356593balminess
battiness11239843battiness
bawdiness15235543bawdiness
boniness102211803bon_iness
bonniness1136733bonniness
caginess11310303ca_giness
cakiness1449553ca_kiness
calcines12314753calcine_s
campiness1537543campiness
candidness1444773candidness
canines93724033can_ine_s
canoness1039393can_oness
cattiness112310633cattiness
crankiness1636173crankiness
daffiness1634843daffiness
dailiness1038673dailiness
daintiness1145963daintiness
dankness13256693dan_kness
dinginess1137823dinginess
earliness939703earliness
easiness8313043ea_siness
faceless13269173fa_celess
faciends1443573fa_ciends
facies113921593fa_ci_e_s
facileness1545513fa_cileness
facings134511263fa_cin_gs
fadedness1445613fadedness
fainest10417703fa__inest
faintness1235833faintness
fairness1136563fa_irness
falconers1445323falconers
falconets1444813falconets
falseness1236093falseness
famines123216263fa_mine_s
fancied133310603fanci_e_d
fancier123412063fanci_e_r
fancifies1767083fancifies
fancifulness2053763fancifulness
fangless1237663fan_gless
fanners103914653fan__ners
fannies103415643fanni_e_s
fanzine1937123fanzine__
farcies125317883farci_e_s
farness102912203fa__rness
fascine12510583fascine__
fastness11238763fa_stness
fatalness1245773fatalness
fatness103311293fa__tness
faultiness1344823faultiness
fenceless1444163fenceless
fencings14225663fencin_gs
fieriness1238633fieriness
filminess1435983filminess
fineness11310653fin_eness
finickiness2052023finickiness
fishiness1537343fishiness
flabbiness1742523flabbiness
flakiness1636473flakiness
flashiness16105283flashiness
flintiness1345903flintiness
flukiness1635453flukiness
foaminess1437503foaminess
fogginess1434973fogginess
fondness1237213fon_dness
forkiness16268703forkiness
foxiness18257403f_oxiness
foziness20257803f_oziness
francizes2346793francize_s
frankness1655223fran_kness
franticness1643603franticness
furriness12287603furriness
fussiness12226583fussiness
fustiness121910243fustiness
fuzziness2033173fuzziness
gabbiness1434413gabbiness
gaminess112911063ga_miness
gassiness10268323gassiness
gaudiness1136263gaudiness
gauziness1934623gauziness
gawkiness1734753gawkiness
hairiness1238013hairiness
hamminess1635713hamminess
happiness1636003happiness
hardiness132310373hardiness
hastiness122410883hastiness
haziness20248513ha_ziness
iciness938863__iciness
inkiness1238693_inkiness
jauntiness1743973jauntiness
jazziness2432843jazziness
juiciness1835153juiciness
kinkiness1235763kinkiness
lanciers10308543lanci_ers
lankness12237043lan_kness
larkiness1338123larkiness
laziness17239983la_ziness
maltiness112910573maltiness
massiness112810143massiness
matiness102114753ma_tiness
maziness19239543ma_ziness
nancies93516843nanci_e_s
nappiness1335233nappiness
nastiness92310573nastiness
nattiness9239333nattiness
packness1636933pa_ckness
pastiness112312363pastiness
patchiness1744933patchiness
paunchiness1842343paunchiness
pawkiness1835453pawkiness
puniness101610273pun_iness
punkiness15226983punkiness
raininess949293raininess
ranchless1444453ranchless
rankness12267943ran_kness
raspiness1137303raspiness
raunchiness1642883raunchiness
runniness9247103runniness
runtiness92410393runtiness
saltiness93312113saltiness
saneness82313723san_eness
sappiness1337443sappiness
sassiness8249333sassiness
savviness1534713savviness
scantiness1236883scantiness
slanginess1146273slanginess
snakiness1367473snakiness
spaciness1337083spaciness
spiciness1347053spiciness
sunniness9247943sunniness
swankiness1744253swankiness
tacitness1134873ta_citness
tackiness1557693tackiness
talkiness1356913talkiness
tardiness10229933tardiness
tarriness9229253tarriness
tartiness92112063tartiness
tastiness92311143tastiness
tattiness9239413tattiness
tawniness1245123tawniness
tininess8310633tin_iness
tinniness936093tinniness
vaccinees1642843vaccinees
vaccines1536503vaccine_s
wackiness1836523wackiness
wanness102610683wan__ness
wariness11313223wa_riness
washiness1537043washiness
waspiness1435793waspiness
waviness1437723wa_viness
waxiness1836723wa_xiness
windiness1337373windiness

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411916.25023782.6
3Display Results1911910.0802387.5
 (SQL Overall)1786911916.75026472.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.