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

268 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
rankness1226794(None) 
dankness13256691dankness
frankness1655221frankness
lankness12237041lankness
rankless12268231rankless
blankness1544672blankness
canoness1039392canoness
crankiness1636172crankiness
darkness13247342darkness
grandness1138302grandness
lankiness1338052lankiness
packness1636932packness
pinkness1436512pinkness
raciness102413452raciness
raininess949272raininess
randiness102511442randiness
ranginess101610212ranginess
rankers113217462rank_ers
rankest112713812rank_est
rankles113114542rankle_s
ranknesses1438092ranknesses
raptness1046732raptness
rareness81112852rareness
rashness1138092rashness
rawness1038152ra_wness
saneness82313722saneness
tankless12267822tankless
wanness102610682wan_ness
zaniness1738662zaniness
ancress978613_ancress
ankles104818383_ankle_s
anklets114310413_anklets
ankuses1148203_ankuses
aptness9268573_aptness
archness1337513archness
aridness939223aridness
artiness81615403artiness
backless162910633backless
badness1039573ba_dness
baldness1137043baldness
balkiness1556903balkiness
bandiness122310243bandiness
bankers133919093bank_ers
banners94018713ban_ners
bannets94013843ban_nets
bareness10912813bareness
barkless14318023barkless
baroness101210063baroness
baseness10910943baseness
bassness1096743bassness
blackness1735663blackness
blandness1235973blandness
boniness102211803boniness
braininess1246123braininess
brandless1236123brandless
branners104010923bran_ners
brashness1436323brashness
braveness14237763braveness
brawniness1544033brawniness
brininess1138203brininess
briskness1544763briskness
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
canines93724033canine_s
cankers134418753cank_ers
cannels93413363can_nels
canners93822663can_ners
canniness1138643canniness
cracknels1743433cracknels
crankest1438143crank_est
crankiest1538823crankiest
crankles143510153crankle_s
crassness1136213crassness
craziness2037383craziness
daftness1235533daftness
dampness1336073dampness
dankest122611673dank_est
danknesses1536253danknesses
doneness9411513doneness
drabness1135803dra_bness
dunness8298983dun_ness
easiness8313043easiness
faintness1235833faintness
fairness1136563fairness
fanciness1437673fanciness
fangless1237663fangless
fanners103914653fan_ners
farness102912203fa_rness
fastness11238763fastness
fatness103311293fa_tness
fineness11310643fineness
fondness1237213fondness
frailness1236533frailness
frankers15348353frank_ers
frankest1536963frank_est
franknesses1845603franknesses
funkiness16226873funkiness
gameness112810693gameness
gaminess112911053gaminess
gannets83811443gan_nets
gastness9278473gastness
gauntness1044203gauntness
gawkiness1734753gawkiness
gayness1136843ga_yness
goneness9310763goneness
graininess1145783graininess
grapiness1238243grapiness
graveness13288383graveness
grayness1235933gra_yness
hackneys2033683hackneys
haleness11312623haleness
halfness1435563halfness
handiness132110933handiness
handless123512063handless
hangnest12311413hangnest
hangnests1344543hangnests
hankers144218133hank_ers
hankies143617763hankie_s
hardness122411083hardness
harness102413933ha_rness
haziness20248513haziness
inaneness948383inaneness
inkiness1238693_inkiness
inkless11348713_inkless
irateness9310493irateness
ironness836953iron_ness
kindness13236653kindness
kinkiness1235763kinkiness
laciness102112553laciness
lameness102612673lameness
landless94011173landless
lankest112714113lank_est
lankiest122912493lankiest
lanknesses1437503lanknesses
lanners73618333lan_ners
larkiness1338113larkiness
lateness82614073lateness
laxness1436043la_xness
laziness17239983laziness
leanness837373lean_ness
loneness8512093loneness
longness938553longness
madness10310073ma_dness
maleness10312313maleness
maneless102812343maneless
manginess122010413manginess
manless93012933man_less
manliness111310123manliness
manners93417833man_ners
matiness102114743matiness
maziness19239543maziness
meanness1037183mean_ness
meekness1434303meekness
nankeens1243243nankeens
oneness7512143_oneness
paleness10312983paleness
paneless102611763paneless
panners93621273pan_ners
pannes85522853pan_ne_s
pastness102510503pastness
patness92912283pa_tness
pawkiness1835443pawkiness
planeness1138153planeness
proneness11310443proneness
puniness101610273puniness
punkiness15226983punkiness
rabidness12145263rabidness
rackers134320453rack_ers
rackets134916873rack_ets
rainless8129703rainless
rakees104516973ra_k_ees
rakers104123573ra_k_ers
rakes94440353ra_k_e_s
rances84625443ran_ce_s
ranchers133311793ranchers
ranches123620113ranche_s
ranchless1444453ranchless
rancidness1344223rancidness
randies84225663randie_s
randiest93418773randiest
randomness1343983randomness
ranees64623963ra__nees
rangers83621043ran_gers
ranges73826923ran_ge_s
rangiest93115983rangiest
ranked114620743rank_e_d
ranker105021903rank_e_r
rankings13389173rankings
rankish14510383rank_ish
rankle103414883rankle__
rankled123910653rankle_d
ranks95225733rank___s
ranters73323643ran_ters
rapidness12155473rapidness
rapines95120863rapine_s
raspiness1137303raspiness
ratines75328583ratine_s
raveners11309123raveners
ravines104220233ravine_s
rayless10239003ra_yless
readiness102611853readiness
realness8410443realness
reckless14257973reckless
redness82012443r_edness
rennets75212633ren_nets
richness1337433richness
rifeness1138583rifeness
riminess10510093riminess
rindless92510193rindless
ripeness1039363ripeness
riskiness1336963riskiness
riskless1235763riskless
rockiness15237833rockiness
rockless14297293rockless
ronnels7318613ron_nels
ropiness102311073ropiness
rosiness82613173rosiness
roundness1047013roundness
rudeness938083rudeness
rungless956733rungless
runkles114111943runkle_s
runless72810423run_less
runnels7329153run_nels
runners74212453run_ners
runniness9247103runniness
runtiness92410393runtiness
sadness8310613sa_dness
safeness11239633safeness
sageness92111983sageness
saltness82610243saltness
sameness102712683sameness
sandiness102111713sandiness
sandless93212343sandless
scantness1135733scantness
sickness1437833sickness
slackness1535433slackness
snakiness1367473snakiness
starkness1335963starkness
swankiness1744253swankiness
tackiness1557693tackiness
tackless14419483tackless
talkiness1356913talkiness
tallness837103tallness
tameness102411253tameness
tanginess10239283tanginess
tankers113416913tank_ers
tanners74018393tan_ners
tannest72617853tan_nest
tartness82210133tartness
tautness8217183tautness
tawniness1245123tawniness
thankless1633203thankless
tininess8310633tininess
trackless15246723trackless
vainness1136063vainness
vanners103612843van_ners
vastness11257293vastness
wackiness1836523wackiness
waeness102512783wa_eness
wankers144514713wank_ers
wannest103915003wan_nest
wariness11313213wariness
warmness1337063warmness
waviness1437723waviness
waxiness1836723waxiness
weakness1535353weakness
wrongness1344513wrongness

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 Filter1786911461620.186960704.3
2DLD Change Limit1461622688.59317009.4
3Display Results2682680.1102436.4
 (SQL Overall)1786912688.88920102.5
 
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.