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

195 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
nursery1039602(None) 
nurser64314501nurser_
nursers74311831nursers
bursary12397582bursary
bursera936762bursera
curser84721472curser_
cursers94317152cursers
cursory12406392cursory
nunnery10355302nunnery
nurse54420122nurse__
nursed74514662nurse_d
nurses63919352nurse_s
purser85020472purser_
pursers93916092pursers
surgery11319202surgery
turnery10357422turnery
artery9911453_artery
berserk1334913berserk
briery114510773_briery
buggery14367933buggery
burger94020793burger_
burgers103918573burgers
burier84324653burier_
buriers94017193buriers
burker125221173burker_
burkers133716623burkers
burler84723833burler_
burlers94120273burlers
burley114715753burle_y
burner83819203burner_
burners94115673burners
burrer83718473burrer_
burrers93814493burrers
burry105221563bur__ry
bursar85413253bursar_
bursars94510893bursars
burse75527253burse__
burseed1049503burseed
burses84425513burse_s
burster9310293burster_
bursters1038983bursters
butlery12369423butlery
buttery124311193buttery
corsetry1365563corsetry
courser94114803courser_
coursers104412293coursers
curber104517053curber_
curbers115514373curbers
curer75030753cur_er_
curers84923183cur_ers
curler85221323curler_
curlers94218063curlers
curriery13326163curriery
curry105920343cur__ry
curse75829143curse__
cursed94321253curse_d
cursedly1444163cursedly
curses85328273curse_s
cursor84110293cursor_
cursors93910023cursors
curter85320073curter_
curtesy1265833curtesy
curtsey1255013curtse_y
curvey144111843curve_y
cusser86016093cusser_
cussers94213393cussers
cutlery12448393cutlery
dorser74819173dorser_
dorsers83516293dorsers
dupery12378743du_pery
fernery1335813fernery
forgery14419303forgery
fullery13337973fullery
furler93616403furler_
furlers104214223furlers
furmety1534813furmety
furriery14395673furriery
furry116719283fur__ry
fusser94813773fusser_
fussers104210813fussers
gunnery11376373gunnery
gurney10429413gurne_y
gurry94515413gur__ry
guttery11427753guttery
horsey125115403horse_y
hurler94717223hurler_
hurlers103714323hurlers
hurley125012523hurle_y
hurry114917183hur__ry
hurter93915853hurter_
hurters103413633hurters
jersey1636333jerse_y
kersey1336783kerse_y
lurer54625313lur_er_
lurers64217493lur_ers
lurker103613293lurker_
lurkers113910083lurkers
mercery14397623mercery
misery114113543_misery
mummery13336663mummery
murder93613783murder_
murders103311363murders
murker123715243murker_
murrey114312253murre_y
murry105120233mur__ry
muser76024123mu_ser_
musers84719093mu_sers
napery11489813n_apery
nitery94412173n_itery
nooser65517823nooser_
noosers74913913noosers
nosey85619883n_ose_y
nudely10299033nu_dely
nuder66416833nu_der_
nudger85111633nudger_
nudgers9479373nudgers
nuggety1234313nuggety
number103913223number_
numbers113711243numbers
nummary14314653nummary
nurled74016233nurle_d
nurseries948013nurseries
nurseryman1551343nurseryman
nurserymen1551413nurserymen
nursing84012553nursing
nurture736643nurture
nutsier7329253nutsier_
nutsy85711503nuts__y
nutter63918053nutter_
nutters74215423nutters
ornery938463_ornery
orrery936783_orrery
ourself1057453ourself
outsert72819513outsert
parser84822373parser_
parsers94118153parsers
prudery1335243prudery
puckery18306263puckery
puffery18235113puffery
pulser84215193pulser_
pulsers94213153pulsers
purely114013613pur_ely
purer75127903pur_er_
purger94717233purger_
purgers104714003purgers
purse76028893purse__
pursed95220883purse_d
purses84826373purse_s
pursier94012753pursier_
pursily1238213pursily
pursuer9338893pursuer_
pursuers10376523pursuers
pursy105016413purs__y
purvey14559573purve_y
quavery22225483quavery
query174212083qu__ery
quivery22265453quivery
rosery93813283_rosery
rubbery14337593rubbery
rudery10419033ru_dery
russety1034613russety
snuggery13253973snuggery
sorcery1237023sorcery
suasory1046043suasory
subsere9311443subsere
sudser73511283sudser_
sudsers83310413sudsers
summery14329413summery
surely93816453sur_ely
surer54833093sur_er_
surety93515003sur_ety
surfer93515883surfer_
surfers103614133surfers
surger74320093surger_
surgers83517483surgers
surrey94414573surre_y
survey124111663surve_y
tersely1038103tersely
terser67317823terser_
turbary1236383turbary
turkey1337763turke_y
turner63914613turner_
turners73912893turners
tushery1335633tushery
tusser64615833tusser_
tussers74313563tussers
unsexy16296903_unsexy
urger64116473_urger_
urgers73313623_urgers
user45023003_u_ser_
users55817573_u_sers
usury887623_u_sury
verser94516963verser_
versers103813513versers
worser95117523worser_

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.1561145455.1
2DLD Change Limit1340271956.55020462.1
3Display Results1951950.0603250.0
 (SQL Overall)1786911956.76626410.1
 
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.