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 “maypole” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
maypole144638(None) 
maypoles1545991maypoles
manhole12311342manhole
maple95521142ma_p_le
mayapple1741702mayapple
maypop1565142maypo_p
maypops16104452maypops
rampole1139692rampole
tadpole1036142tadpole
amole75724593_a_mole
ample94720303_amp_le
ampoule11116603_ampoule
ampule10710613_ampule
amylose1237193amylose
anole55330383_a_nole
apple94517673_a_pple
appose10411993_appose
areole61017283_areole
azole145118033_a_zole
beanpole1244333beanpole
cajole154011183ca_jole
capote10315733ca_pote
cariole9818343cariole
carpale113414353carpale
dapple1138853da_pple
dariole8711163dariole
dipole91112853_dipole
flagpole1443583flagpole
haole84820083ha__ole
keyhole1764433keyhole
laypeople1651523laypeople
mackle143716433ma_ckle
macle96127003ma__cle
macule104115273ma_cule
madrone102812663madrone
magpie1139093magp_ie
mahoe10315573ma_ho_e
maile75232223ma__ile
makable15510203makable
male66052303ma___le
malposed1344563malposed
maltol8310843maltol_
maltols939403maltols
maltose939793maltose
manacle11310283manacle
mandola1039023mandola
mangle93921333ma_ngle
mangold1137213mangold
manholes13311183manholes
manille92613273manille
maniple11249653maniple
mannose939243mannose
manpower1544703manpower
manrope1138033manrope
mantle84420923ma_ntle
manyfold1792743manyfold
maples104819423ma_p_les
mappable1635923mappable
marble104219103ma_rble
marplot1149673marplot
mausolea1043073mausolea
mayapples1841693mayapples
maybe12311133may__be
mayfly1734403may_fly
mayo96524303may_o__
mayor106616623may_o_r
mayors115714193may_ors
mayos105521933may_o_s
midsole1037813midsole
mole66251833m___ole
monopole1249283monopole
mopoke1436633m_opoke
mudhole1344913mudhole
mycele1335853m_ycele
myope124010973m_y_ope
myrtle1135733m_yrtle
pappose1047413pappose
papule102212133pa_pule
parole84425253pa_role
payable141711323payable
payola11208113pay_ola
payroll1245613payroll
pole65951303___pole
rampoles1238893rampoles
rathole10312053rathole
safrole1037253safrole
sample104215013samp_le
sapote8314363sa_pote
sayable121411613sayable
tadpoles1135953tadpoles
taphole1239773taphole
vacuole1245373vacuole
variole10711593variole
zeppole2043493zeppole

Search took 8 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 Limit134027946.70319995.1
3Display Results94940.0462043.5
 (SQL Overall)178691947.15524974.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.