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

174 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
manuary123777(None) 
angary10311322_angary
canary11314692can_ary
laniary1068012laniary
mammary1335992mammary
mangaby1535352mangaby
mansard1049312mansard
manual8313462manua_l
manually1347042manually
manuals9311212manuals
manure8313652manu_re
manward1349092manward
actuary1245613actuary
alary86123443_a_lary
ambary134010543_ambary
anear55420323_anear_
anears63717183_anears
angry9310863_an_gry
anural65714743_anural
anuran64313243_anuran
apiary113910383_apiary
ariary94114203_ariary
aviary12338413_aviary
aweary1237303_aweary
binary11312223bin_ary
calvary1537183calvary
canard9314763can_ard
cannery123610013cannery
canonry1235923canonry
canular9310323canular_
datary10310243da_tary
daubry12445483da_ubry
denary105316863den_ary
estuary1034683estuary
fanfare1336673fanfare
fantasy1336153fantasy
gantry103810113gan_try
gauntry1154113gauntry
granary1157793gran_ary
hangar104114503hangar_
hangars114313483hangars
jaggary19304863jaggary
jaguar1435283jaguar_
jaguars1535223jaguars
janisary1843623janisary
janizary2742483janizary
kantar10311153kantar_
kantars11310033kantars
kaury12429763ka_u_ry
lactary1237843lactary
lacunary13114153lacunary
laniard868523laniard
lanyard1167293lanyard
laundry1133513laundry
maar66025053ma__ar_
maars74621633ma__ars
macular113011943macular_
maduro936973madu_ro
maguey1236833magu_ey
mahuang1372883mahuang
makar115614973ma_kar_
makars124612633ma_kars
malady1237863ma_lady
malar76424443ma_lar_
malarky1645433ma_larky
malars85020683ma_lars
mallard10310273mallard
mana65341943man_a__
manage93818903man_age
manana84816073man_ana
manas76240423man_a_s
manat76039983man_a_t
manats84623463man_ats
mandala10310203mandala
mandarin11411013mandarin
mandatary1543243mandatary
mandate10315573mandate
mandatory1545243mandatory
manfully1645653manfully
manga85026193manga__
mangabey1643463mangabey
mangas94122923manga_s
manger94325003manger_
mangers103521263mangers
mangey123614523man_gey
mangily1339753mangily
mangy115021233man__gy
mania75634143mania__
maniac103917973mania_c
maniacs114313063maniacs
manias84029033mania_s
manlily1238743manlily
manly105022943man__ly
manmade1237963manmade
manna75522533manna__
mannan85413623manna_n
mannans93611523mannans
mannas85019803manna_s
manner84020513manner_
mannerly1344983mannerly
manners93417833manners
manor78023923man_or_
manors84420883man_ors
manpack1746063manpack
mansards1148013mansards
manta75629903manta__
mantas85725363manta_s
mantra84116093man_tra
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
mantua84412023mantua__
mantuas93410993mantua_s
manubria1243483manubria
manumit1149573manumit
manured1039473manured
manurer938583manurer
manurers1037593manurers
manures9313353manures
manus75924923manu__s
manwards1447613manwards
many95731843man___y
margay12310593marga_y
marry104821693ma__rry
martyry1533373martyry
mascara1138023mascara
masonry1244123masonry
mastery124214323mastery
mattery123810713mattery
mature8313463matu_re
maugre9308973ma_ugre
maundy12506783ma_undy
mayday1535873mayda_y
mazard1838763ma_zard
mazzard1844463mazzard
miliary1249463miliary
monetary1346523monetary
monkery16317453monkery
mortary12369043mortary
mortuary1373923mortuary
murry105120233m__urry
nary76931223__n_ary
ossuary1043943ossuary
palmary14338553palmary
panfry14456413pan_fry
pantry115014103pan_try
penury1148103penu_ry
quandary2143433quandary
ranular739433ranular_
saguaro845513saguaro
sahuaro1044233sahuaro
salary9515213sa_lary
salutary1145113salutary
sanctuary1442183sanctuary
sangar73617683sangar_
sangars83116253sangars
sanitary1146753sanitary
sansar63613393sansar_
sansars73313913sansars
saury84317223sa_u_ry
senary93716073sen_ary
stannary1144613stannary
statuary1144033statuary
tanbark1337373tanbark
tankard1267263tankard
tannery10388663tannery
tantara72410813tantara
tanyard1167183tanyard
unary8315993_un_ary
unwary1239823_unwary
vagary1337333va_gary
vanguard1343893vanguard
vanward1456943vanward
zonary1838793zon_ary

Search took 10 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 Limit1340271749.11014712.1
3Display Results1741740.0632761.9
 (SQL Overall)1786911749.32919154.4
 
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.