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

167 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
mayhap163523(None) 
madcap1336332madcap
maya95824582may_a_
mayan105616902may_an
mayas105924382may_as
mayday1535872mayday
mayhem1644922mayhem
maypop1565142maypop
mishap1338862mishap
agha87417303_agha_
aghas97014873_aghas
aha611246643_a_ha_
arhat8327093_arhat
atap66722453_a_tap
ayah108022993_ay_ah
ayahs116813523_ayahs
barhop13319643barhop
bashaw14349303bashaw
bayman133712703bayman
carhop133610763carhop
cashaw14439793cashaw
catnap1098383catnap
cayman133613213cayman
chap114928493__chap
dacha114812573dacha_
dachas124113253dachas
earlap837183earlap
gayal9312713gay_al
gaydar1135503gaydar
haha107821063ha_ha_
hahas117118443ha_has
hap87360053___hap
jalap143612473ja_lap
kasha124710723kasha_
kashas133311903kashas
kayak1138363kay_ak
lahar83114263la_har
layman113511303layman
layup1037723lay_up
maar66025053ma__ar
macaw12311763ma_caw
mach116134473mach__
mache125925303mach_e
maches134827233maches
macho126120153mach_o
machos135217493machos
machs125722563mach_s
madam10316223ma_dam
madcaps1435243madcaps
madman113712383madman
madras94316423madras
maenad939413maenad
mafia104418033mafia_
mafias113913573mafias
magian9312833magian
magilp1137613magilp
magma104513573magma_
magmas115512503magmas
mahoe10315573ma_hoe
maihem1366213maihem
makar115614973ma_kar
makeup1434863makeup
malar76424443ma_lar
maltha1137503maltha_
malthas1237913malthas
mama86231583ma_ma_
mamas95930773ma_mas
mamba116317513mamba_
mambas125716243mambas
mamma86317913mamma_
mammae94613213mammae
mammal95112753mammal
mammas94616403mammas
mana65341943ma_na_
manas76240423ma_nas
manat76039983ma_nat
manga85026193manga_
mangas94122923mangas
mania75634143mania_
maniac103917973maniac
manias84029033manias
manna75522533manna_
mannan85413623mannan
mannas85019803mannas
manta75629903manta_
mantas85725363mantas
mantrap11379823mantrap
manual8313463manual
map77255113m___ap
mara67444563ma_ra_
maras75443283ma_ras
margay12310593margay
maria75032883maria_
marka114620793marka_
markas124717003markas
markup1436903markup
marram10313883marram
marshal1238973marshal
masa65034713ma_sa_
masas75630413ma_sas
mash96039393mash__
mashed125325043mashed
masher114123203masher
mashes115030003mashes
mashie11315933mashie
mashy136016503mash_y
massa75518923massa_
massas85116463massas
matchup1643513matchup
math95437443math__
maths105624023math_s
matsah1138233matsah
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
may88757623may___
maybe12311123may_be
maybes1339243maybes
maydays1634483maydays
mayed115522403may_ed
mayest114614793mayest
mayfly1734403mayfly
mayhappen215983mayhappen
mayhems1763413mayhems
maying124421153maying
mayo96524293may__o
mayor106616623may_or
mayoral1237683mayoral
mayors115714193mayors
mayos105521933may_os
maypops16104453maypops
mays96940023may__s
mayst106622673may_st
mayvin1436523mayvin
midcap1336473midcap
mishaps1438713mishaps
mobcap1444113mobcap
mocha1249923mocha_
mochas13310653mochas
moshav1446053moshav
mudcap1335133mudcap
mughal1236263mughal
mylar105311533m_ylar
myna95815293m_yna_
mynah13569563m_ynah
mynas105815233m_ynas
nachas114914193nachas
naysay1234973naysay
pacha126518063pacha_
pachas135017143pachas
pasha105417183pasha_
pashas115117063pashas
payday1536613payday
raphae114311733raphae
raya75224823ray_a_
rayah116013503ray_ah
rayahs12579193rayahs
rayas85922053ray_as
sashay1238363sashay
satrap86212553satrap
skycap1742913skycap
smashup1443453smashup
washup1435323washup
watap102111673wa_tap
waylay1535453waylay
whap125119643__whap
yap85949823__y_ap

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161675.90619085.0
3Display Results1671670.0463630.4
 (SQL Overall)1786911676.09229332.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.