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

181 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
mahzors213512(None) 
machzors2444111machzors
mahzor2035111mahzor_
machzor2344262machzor_
mahoes11313102mah_oes
mahzorim2442532mahzorim
majors154511092ma_jors
mamzers20409162mamzers
manors84420882ma_nors
matzohs2134372matzohs
matzos1749262matzo_s
mayors115714192ma_yors
mazers173917092ma_zers
razors154711652ra_zors
abhors11410623_abhors
actors81016753_actors
ahorse9311513_ah_orse
algors7312553_algors
amazons1836643amazons
arbors84717873_arbors
ardors74416863_ardors
armors85017813_armors
azons146518253_a_zons
bailors93212403bailors
bazars174613113ba_zars
bazoos173212623ba_zoos
cahiers123510673cahiers
cahoots1238473cahoots
cahows14399123cah_ows
candors104216763candors
cantors94620753cantors
captors113914983captors
castors94919433castors
chadors1338723chadors
dahoons1137753dahoons
ephors11311403eph_ors
factors12912123factors
favors124211403fa_vors
gators74115823ga_tors
gazars164811553ga_zars
gazers164516293ga_zers
gazoos163010223ga_zoos
harbors12412413harbors
haviors1347383haviors
hazers184615953ha_zers
ichors11310413ich_ors
jailors14328743jailors
jazzers22324763jazzers
kazoos19259113ka_zoos
labors84016403la_bors
lahars94013163lah_ars
lazars153812393la_zars
maars74621633ma__ars
macers105321273ma_cers
machos135217493macho_s
machzorim2751703machzorim
macons104017243ma_cons
macrons113514893macrons
macros104017013macro_s
madders113513213madders
madtoms1236923madtoms
maduros1036283maduros
madwort13611363madwort
madworts1456173madworts
madzoon1996063madzoon
madzoons20124773madzoons
maftirs1236043maftirs
maggots1136553maggots
magots9312363ma_gots
mahjong2042273mahjong
mahjongs2141813mahjongs
mahoe10315573mah_o_e
mahout11415803mah_out
mahouts1237143mahouts
mailers94420333mailers
maimers113813043maimers
mairs76228303ma__irs
maizes175115733maiz_es
major145212923ma_jor_
makars124612633ma_kars
makers123921733ma_kers
makos116518363ma_ko_s
malars85020683ma_lars
mallows123714323mallows
malodors1144973malodors
maltols939403maltols
mamboes135011823mamboes
mambos125414493mambo_s
mammers104615693mammers
mammons1048513mammons
mamzer19459833mamzer_
mangers103521263mangers
mangoes104316133mangoes
mangos94319333mango_s
manhoods1447243manhoods
maniocs113611443maniocs
manners93417833manners
manor78023923ma_nor_
manos74933613ma_no_s
mappers133313773mappers
markers133516103markers
markhoors1842703markhoors
markhors1745393markhors
marmots11311513marmots
maroons92615553maroons
marrers93414313marrers
marrons93216973marrons
marrows122911813marrows
mars66261863ma___rs
martyrs1234893martyrs
mascons113411583mascons
mascots113910343mascots
masers84623453ma_sers
mashers124621053mashers
maskers133913833maskers
masons83916513ma_sons
masters94628923masters
matadors1156963matadors
maters85032383ma_ters
matrons93517633matrons
matters94421753matters
matzahs2134483matzahs
matzas1749703matz_as
matzo16312893matzo__
matzoh2035483matzo_h
matzoon1896473matzoon
matzoons19105083matzoons
matzot17710983matzo_t
matzoth2144333matzoth
maulers94213303maulers
mayor106616623ma_yor_
mayos105521933ma_yo_s
maypops16104453maypops
mazard1838763ma_zard
mazards1937703ma_zards
mazer165722423ma_zer_
mazes165632173ma_z_es
mazzard1844463mazzard
mazzards1943943mazzards
mentors9314993mentors
meteors94610013meteors
mezzos1635043mezzo_s
mhos95517773m_h_o_s
minors85117093m_inors
mirrors938623mirrors
mohairs1234953mohairs
mohurs1135933moh_urs
momzers20367133momzers
moors74923143m__oors
mors65950063m___ors
motors84616593m_otors
mozos165516333m_ozo_s
mucors104410843m_ucors
pallors9314353pallors
panzers184012013panzers
parlors9312913parlors
pastors94118993pastors
patzers184210573patzers
paviors1237603paviors
pawnors12297203pawnors
payors114312643pa_yors
rancors9811373rancors
raptors94213353raptors
razers154919613ra_zers
razor143012603ra_zor_
sailors73213713sailors
salvors103910903salvors
sapors84118813sa_pors
sartors7314953sartors
saviors1058993saviors
savors95616103sa_vors
seizors16328993seizors
tabors84517093ta_bors
tahrs85412333tah__rs
tailors73212383tailors
valors93413773va_lors
vapors113812693va_pors
vizors18328903_vizors
wahoos122310593wah_oos
wazoos18288553wa_zoos
yahoos12209243yah_oos

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271818.04616657.6
3Display Results1811810.0762381.6
 (SQL Overall)1786911818.27821586.3
 
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.