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

93 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
keypads174334(None) 
keypad1633821keypad_
keypals1634351keypals
keycards1843062keycards
keypal1534892keypa_l
keyways2043372keyways
kneepads15102252kneepads
beads85429503be__ads
bedpans1237173bedpans
beglads11127263beglads
beheads1338523beheads
beyonds1335063beyonds
bypass1345043_bypass
cycads14476213_cycads
deads75726913de__ads
deleads9379703deleads
dryads11436623dry_ads
dyads10549973_dy_ads
egads74610923_e_gads
expands17195733_expands
expats1537683_expats
eyas76427433_ey_a_s
eyass84410783_ey_ass
eyras84715923_eyra_s
frypans1544053frypans
heads95127113he__ads
helipads1443873helipads
heptads1335873heptads
hexads17468193he_xads
heydays1734143heydays
jehads1735833je_hads
jeopards1843683jeopards
kalpacs15327133kalpacs
kalpaks12366163kalpaks
kalpas124112943kalpa_s
kapas116021733k_apa_s
kappas144410363kappa_s
kayaks1236333kay_aks
keas86337093ke__a_s
kebabs14418513ke_babs
kebars124112493ke_bars
keblahs1634563keblahs
keddahs1642923keddahs
keepers133410983keepers
keeps116020283keep__s
keloids1288663keloids
kelped13449553kelped_
kelpies13289903kelpies
kelps115116423kelp__s
kemps135012523kemp__s
kenafs1337113ke_nafs
kepis115313363ke_p_is
kepped15309543kepped_
keps106027303ke_p__s
kewpies16246923kewpies
keyboards1943963keyboards
keycard1743663keycard
keyed1369393key_ed_
keyless1436163keyless
keys116322163key___s
keysets1434343keysets
keyway1943823keywa_y
keywords1944323keywords
kneads11357093k_neads
kneepad1462373kneepad_
kneepans1462733kneepans
koppas14407603koppa_s
kyaks11459163k_y_aks
kyars124813963k_y_ars
kyats125012443k_y_ats
lampads12477623lampads
leads66028493le__ads
leopards1144753leopards
meads85425323me__ads
menads95514383me_nads
pads76742953___pads
pentads1039523pentads
reads64835273re__ads
reclads1049993reclads
reloads8911313reloads
repass84114703re_pass
repays113813973re_pays
rereads81512293rereads
respade1039573respade
respades1139853respades
reynards1244303reynards
secpars1138413secpars
sepals85217373se_pals
teopans939203teopans
tepals85415043te_pals
tepas76521683te_pa_s
tetrads82910193tetrads
vespids1334613vespids

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.420425454.8
2DLD Change Limit134027937.06318975.9
3Display Results93930.0303100.0
 (SQL Overall)178691937.51323784.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.