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

105 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
maypops1610445(None) 
maypop1565141maypop_
joypops2162602joypops
mayors115714192may_ors
mayos105521932may_o_s
maypole1446382maypole
maypoles1545992maypoles
apods86316343_a_pods
apos65433823_a_po_s
apps86319693_a_p_ps
barhops14288113barhops
bayous11411153bay_ous
campos125217953campo_s
capons104119503ca_pons
capos94826073ca_po_s
carhops14329703carhops
coypous14248813coypous
gallops103211653gallops
galops94712623ga_lops
haymows1883813haymows
hypos1312014743_hypo_s
jalops15329593ja_lops
joypop2063133joypop_
kapoks11347263ka_poks
kayoes134710823kay_oes
kayos127714703kay_o_s
laptops1166603laptops
layups1133993lay_ups
machos135217493macho_s
macons104017243ma_cons
macrons113514893macrons
macros104017013macro_s
madcaps1435243madcaps
madtoms1236923madtoms
maggots1136563maggots
magilps1234083magilps
magots9312363ma_gots
magpies12310363magpies
mahoes11313103ma_hoes
mahzors2135123mahzors
maintops1244403maintops
majors154511093ma_jors
makeups1533603makeups
makos116518363ma_ko_s
malaprops1543253malaprops
mallows123714323mallows
maltols939403maltols
mamboes135011823mamboes
mambos125414493mambo_s
mammons1048513mammons
mangoes104316133mangoes
mangos94319343mango_s
maniocs113611443maniocs
manors84420883ma_nors
manos74933623ma_no_s
manrope1138033manrope
manropes1237913manropes
maples104819423ma_ples
mappers133313783mappers
maps86141053ma___ps
markups1534963markups
marmots11311513marmots
maroons92615553maroons
marplots1245633marplots
marrons93216973marrons
marrows122911823marrows
mascons113411583mascons
mascots113910343mascots
masons83916513ma_sons
matrons93517633matrons
matzohs2134373matzohs
matzos1749263matzo_s
mayas105924383may__as
maybes1339243may_bes
maydays1634493maydays
mayhap1635233mayhap_
mayhems1763413mayhems
mayings134410513mayings
mayo96524303may_o__
mayor106616623may_o_r
mays96940033may___s
mayvins1535323mayvins
mops85940133m___ops
myope124010973m_y_ope
myopes13419963m_yopes
myopy15457353m_y_opy
pappous1057463pappous
payors114312643pay_ors
pops86340953___pops
psyops1334343psy_ops
ragtops1035453ragtops
rayons94113343ray_ons
saloops93510133saloops
sannops936693sannops
sapors84118813sa_pors
sysops1136013_sysops
tampons112711563tampons
tarpons92612213tarpons
typos106015813_typo_s
typps12549303_typ_ps
vapors113812693va_pors
wallops123410413wallops
yapoks15346783ya_poks
yapons114411773ya_pons
yaupons12345683yaupons

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.406440125.6
2DLD Change Limit1340271058.42315912.0
3Display Results1051050.0462282.6
 (SQL Overall)1786911058.87520134.2
 
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.