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

221 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
nunnery1035530(None) 
gunnery11376371gunnery
cannery123610012cannery
cunner83915002cunner_
cunners93913472cunners
dunner73913822dunner_
funner93414102funner_
gunner73813982gunner_
gunners83111732gunners
hennery1335302hennery
nursery10396022nursery
punner84918152punner_
punners94114232punners
runner63814462runner_
runners74212452runners
tannery10388662tannery
turnery10357422turnery
banner84421503banner_
banners94018713banners
beanery1237563beanery
bindery13459833bindery
buggery14367933buggery
bunker124519373bunker_
bunkers133715953bunkers
bunny104715803bunn__y
bunter85020383bunter_
bunters94717123bunters
burner83819203burner_
burners94115673burners
butlery12369423butlery
buttery124311193buttery
canner84625983canner_
canners93822663canners
cindery13429193cindery
conner84423963conner_
conners94023113conners
cutlery12448393cutlery
deanery1137613deanery
dinner74217163dinner_
dinners83915443dinners
donnerd9427813donnerd
donnert82815533donnert
dunker113616463dunker_
dunkers123512193dunkers
dunned85015523dunne_d
dunness8298983dunness
dunnest83312263dunnest
dupery12378743du_pery
enginery1244563enginery
fanner94218183fanner_
fanners103914653fanners
fernery1335813fernery
finery124512893_finery
fullery13337973fullery
funder104016083funder_
funders113813933funders
funker133915763funker_
funkers143712063funkers
funned103613953funne_d
funnel93610743funne_l
funnels10348173funnels
funnest102912003funnest
funnier103210173funnier_
funnily1336373funnily
funny114614833funn__y
gingery12368913gingery
ginner73915823ginner_
ginners84314223ginners
gunned83513093gunne_d
gunnel73411053gunne_l
gunnels8358563gunnels
gunnen7338713gunne_n
gunny94413663gunn__y
gurney10429413gurne_y
guttery11427763guttery
hunger104015203hunger_
hungers114013303hungers
hungry1334973hu_ngry
hunker133917673hunker_
hunkers143314333hunkers
hunkey164210883hunke_y
hunter94817773hunter_
hunters103915733hunters
inner54920633_inner_
innerly1037133_innerly
inners63919353_inners
joinery17366593joinery
junker174213653junker_
junkers184010863junkers
lanner64920603lanner_
lanners73618333lanners
lunger75720423lunger_
lungers83817093lungers
lunier64617603lunier_
lunker104718343lunker_
lunkers113414603lunkers
manner84020513manner_
mannerly1344983mannerly
manners93417833manners
monkery16317453monkery
mummery13336663mummery
nanny84813813nann__y
napery11489813n_apery
ninety9510963n_inety
ninny84514933ninn__y
nitery94412173n_itery
nonenergy1352863nonenergy
nonentry1146813nonentry
nonhero1057913nonhero
noninert8415023noninert
nonjury1744033nonjury
nonnews1035313nonnews
nonzero1646123nonzero
nudely10299033nu_dely
nuder66416833nu_der_
nudger85111643nudger_
nudgers9479373nudgers
nuggety1234313nuggety
number103913223number_
numbers113711243numbers
nummary14314653nummary
nunneries947113nunneries
nunnish1035933nunnish
nurser64314503nurser_
nursers74311833nursers
nutter63918053nutter_
nutters74215433nutters
onery8414123__onery
ornery938463_ornery
panner84224763panner_
panners93621273panners
penner84616663penner_
penners93414183penners
pinery115214293_pinery
pinner84521503pinner_
pinners93518603pinners
puckery18306263puckery
puffery18235113puffery
punier84519223punier_
punker123718823punker_
punkers133714853punkers
punkey154011173punke_y
punned93416193punne_d
punnet83518843punne_t
punnets9409263punnets
punnier93511263punnier_
punny104217713punn__y
punter84320023punter_
punters93617043punters
quavery22225483quavery
query174212083qu__ery
quinary1936933quinary
quivery22265463quivery
rubbery14337593rubbery
rudery10419033ru_dery
ruiner64013643ruiner_
ruiners74213023ruiners
runnel63510663runne_l
runnels7329153runnels
runnier74010113runnier_
runny84613483runn__y
scenery1236563scenery
scunner9358243scunner_
scunners10357303scunners
shinnery14305673shinnery
shunner10358643shunner_
shunners11317743shunners
sinner64320603sinner_
sinners74019023sinners
sneery93610413_sneery
snuggery13253973snuggery
spinnery13416593spinnery
stunner7349193stunner_
stunners8277923stunners
summery14329413summery
sunder74019823sunder_
sunders84120053sunders
sundry1057943su_ndry
sunned74216323sunne_d
sunnier73412153sunnier_
sunnily1037833sunnily
sunny84917743sunn__y
surgery11319213surgery
swannery1433553swannery
tanner63722283tanner_
tanners74018393tanners
tenner64117103tenner_
tenners74014923tenners
thundery1533823thundery
tindery11389363tindery
tinner64119963tinner_
tinners73717313tinners
tonner64819203tonner_
tonners73816403tonners
tuner56022683tu_ner_
tuners64417343tu_ners
tunned74014493tunne_d
tunnel64310633tunne_l
tunnels7328723tunnels
tunny86515033tunn__y
turner63914613turner_
turners73912893turners
tushery1335633tushery
unary8315993_u_nary
under64624213_under_
unmerry1245023_unmerry
unnerve1066653_unnerve
unsexy16296903_unsexy
unwary1239823_unwary
unweary1335843_unweary
vanner94215843vanner_
vanners103612843vanners
venery123710663_venery
vinery124912603_vinery
wanner94019623wanner_
winery125014283_winery
winner94219933winner_
winners104316913winners
wintery13399753wintery
wonner95114443wonner_
wonners104312813wonners

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 Filter1786911340270.453394461.4
2DLD Change Limit1340272216.20321606.8
3Display Results2212210.0762907.9
 (SQL Overall)1786912216.73226543.5
 
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.