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

193 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
mahzor203511(None) 
machzor2344261machzor
mahzors2135121mahzors
machzors2444112machzors
mahoe10315572mah_oe
mahzorim2442542mahzorim
major145212922ma_jor
mamzer19459832mamzer
manor78023932ma_nor
matzo16312892matzo_
matzoh2035482matzoh
matzos1749262matzos
matzot17710982matzot
mayor106616622ma_yor
mazer165722422ma_zer
razor143012602ra_zor
abhor10411063_abhor
actor71116073_actor
ahoy101919183_ah_oy
algor6513053_algor
amazon1736833amazon
arbor74818113_arbor
ardor64617863_ardor
armor75118053_armor
azo128233393_a_zo_
azon135725053_a_zon
bailor83412603bailor
bazar163816003ba_zar
bazoo163815673ba_zoo
cahier113615773cahier
cahoot11416473cahoot
cahow135110943cah_ow
candor94516423candor
cantor85621523cantor
captor104914603captor
castor84418533castor
chador1238673chador
dahoon1039053dahoon
ephor10310013eph_or
factor11911453factor
favor114712453fa_vor
gator64416033ga_tor
gazar154612983ga_zar
gazer155720073ga_zer
gazoo153112873ga_zoo
harbor11410723harbor
havior1248203havior
hazer174820233ha_zer
ichor1039483ich_or
jailor13418573jailor
jazzer21376503jazzer
kazoo183311533ka_zoo
labor75117313la_bor
lahar83114263lah_ar
lazar144113643la_zar
maar66025063ma__ar
macer912126943ma_cer
macho126120153macho_
machos135217493machos
machzorim2751703machzorim
macon94519953ma_con
macro94718173macro_
macron103615673macron
macros104017013macros
madder103515593madder
madtom1138023madtom
maduro936983maduro
madwort13611363madwort
madzoon1996063madzoon
maftir1136493maftir
maggot10311713maggot
magot8326393ma_got
mahjong2042273mahjong
mahoes11313103mahoes
mahout11415803mahout
mailer84724183mailer
maimer104514593maimer
mair66133783ma__ir
maize164618563maiz_e
maizes175115733maizes
majors154511093ma_jors
makar115614973ma_kar
maker114127813ma_ker
mako105622363ma_ko_
makos116518363ma_kos
malar76424443ma_lar
mallow114014743mallow
malodor1044563malodor
maltol8310843maltol
mambo115215743mambo_
mambos125414493mambos
mammer94218863mammer
mammon939643mammon
mamzers20409163mamzers
manger94325003manger
mango85724323mango_
mangos94319333mangos
manhood1338993manhood
manioc103914823manioc
manner84020513manner
mano66536813ma_no_
manors84420883ma_nors
manos74933623ma_nos
mapper124516093mapper
mar57965953ma___r
marker124420393marker
markhoor1742973markhoor
markhor1635463markhor
marmot10318743marmot
maroon83118203maroon
marrer83716673marrer
marron83717543marron
marrow112812603marrow
martyr1135693martyr
mascon103612743mascon
mascot104016073mascot
maser75029973ma_ser
masher114123203masher
masker124416103masker
mason74820183ma_son
master84831343master
matador1066253matador
mater74438863ma_ter
matier84321523matier
matron83918313matron
matter84325343matter
matza16311813matz_a
matzah2035963matzah
matzas1749703matzas
matzohs2134373matzohs
matzoon1896473matzoon
matzoth2144333matzoth
mauger93813483mauger
mauler84416713mauler
mayo96524303ma_yo_
mayors115714193ma_yors
mayos105521933ma_yos
maypop1565143maypop
mazard1838763ma_zard
maze155434983ma_z_e
mazed175523873ma_zed
mazers173917093ma_zers
mazes165632173ma_zes
mazier175013063mazier
mazy186419703ma_z_y
mazzard1844463mazzard
mentor8414363mentor
meteor84910073meteor
mezzo1537433mezzo_
mezzos1635053mezzos
mho86624623m_h_o_
mhos95517773m_h_os
minor74920063m_inor
mirror848003mirror
mohair1135203mohair
mohur1036513moh_ur
momzer19327553momzer
moor66628553m__oor
mor56855003m___or
motor75317293m_otor
mozo157719743m_ozo_
mozos165516333m_ozos
mucor94011943m_ucor
pallor8313673pallor
panzer174213233panzer
parlor8312673parlor
pastor84817483pastor
patzer173111643patzer
pavior1138533pavior
pawnor11357243pawnor
payor105413843pa_yor
rancor8810373rancor
raptor83912823raptor
razer144824273ra_zer
razors154711663ra_zors
sailor63113753sailor
salvor94711093salvor
sapor75119253sa_por
sartor6313883sartor
savior9710173savior
savor85417943sa_vor
seizor15428533seizor
tabor75518393ta_bor
tahr75217153tah__r
tailor63412503tailor
valor83614893va_lor
vapor104013093va_por
vizor173010093_vizor
wahoo112413083wah_oo
wahoos122310593wahoos
wazoo173011173wa_zoo
yahoo112911543yah_oo
yahoos12209243yahoos

Search took 6 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 Filter1786911127160.453394461.4
2DLD Change Limit1127161934.83023336.6
3Display Results1931930.0603216.7
 (SQL Overall)1786911935.34333443.9
 
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.