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

124 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
maypop156514(None) 
maypops16104451maypops
joypop2063132joypop
mayhap1635232mayhap
mayo96524302may_o_
mayor106616622may_or
mayos105521932may_os
maypole1446382maypole
apo511142123_a_po_
apod78123183_a_pod
apos65433823_a_pos
app76827603_a_p_p
atop66124753_a_top
barhop13319643barhop
bayou10512363bay_ou
campo115219763campo_
campos125217953campos
capo85829213ca_po_
capon95221873ca_pon
capos94826073ca_pos
carhop133610763carhop
cartop104213563cartop
coypou13268403coypou
gallop93311383gallop
galop84716223ga_lop
haymow1773683haymow
hypo127516353_hypo_
hypos1312014743_hypos
jalop144212603ja_lop
joypops2162603joypops
kapok10448783ka_pok
kayo116417553kay_o_
kayos127714703kay_os
laptop1076813laptop
layup1037723lay_up
macho126120153macho_
machos135217493machos
macon94519953ma_con
macro94718173macro_
macron103615673macron
macros104017013macros
madcap1336333madcap
madtom1138023madtom
maggot10311713maggot
magilp1137613magilp
magot8326393ma_got
magpie1139093magpie
mahoe10315573ma_hoe
mahzor2035113mahzor
maintop1135143maintop
major145212923ma_jor
makeup1434863makeup
mako105622363ma_ko_
makos116518363ma_kos
malaprop1443073malaprop
mallow114014743mallow
maltol8310843maltol
mambo115215743mambo_
mambos125414493mambos
mammon939643mammon
mango85724323mango_
mangos94319333mangos
manioc103914823manioc
mano66536813ma_no_
manor78023933ma_nor
manos74933623ma_nos
manrope1138033manrope
map77255123ma___p
maple95521143ma_ple
mapped134015883mapped
mapper124516093mapper
maps86141053ma_p_s
markup1436903markup
marmot10318743marmot
maroon83118203maroon
marplot1149673marplot
marron83717543marron
marrow112812603marrow
mascon103612743mascon
mascot104016073mascot
mason74820183ma_son
matron83918313matron
matzo16312893matzo_
matzoh2035483matzoh
matzos1749263matzos
matzot17710983matzot
may88757633may___
maya95824593may__a
mayan105616903may_an
mayas105924383may_as
maybe12311133may_be
maybes1339243maybes
mayday1535883mayday
mayed115522403may_ed
mayest114614793mayest
mayfly1734403mayfly
mayhem1644923mayhem
maying124421153maying
mayors115714193mayors
maypoles1545993maypoles
mays96940033may__s
mayst106622673may_st
mayvin1436523mayvin
mop76950823m___op
myope124010973m_yope
myopy15457353m_yopy
payor105413843pay_or
pop76252253___pop
ragtop936683ragtop
rayon83815703ray_on
saloop84212583saloop
sannop837373sannop
sapor75119253sa_por
sysop1037193_sysop
tampon102911233tampon
tarpon82812803tarpon
typo95418123_typo_
typos106015813_typos
typp115812783_typ_p
vapor104013093va_por
wallop113310293wallop
yapok14468153ya_pok
yapon104613583ya_pon
yaupon11345493yaupon

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.390458182.1
2DLD Change Limit1127161245.54620323.8
3Display Results1241240.0304133.3
 (SQL Overall)1786911245.96629951.6
 
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.