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

140 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
keypad163382(None) 
keypads1743341keypads
keypal1534891keypal
kelped13449552kelped
kepped15309542kepped
keycard1743662keycard
keyed1369392key_ed
keypals1634352keypals
keyway1943822keyway
kneepad1462372kneepad
bead75937923be__ad
bedpan1137583bedpan
beeped115313453beeped
beglad10138463beglad
behead1239923behead
beyond1237073beyond
cycad13507273_cycad
dead65434243de__ad
delead84112343delead
dryad10477583dry_ad
dyad96415453_dy_ad
egad64215413_e_gad
expand16236573_expand
expat14313813_expat
eyas76427433_ey_as
eyed86623233_ey_ed
eyra76217553_eyra_
eyras84715923_eyras
frypan1434543frypan
head87137173he__ad
heaped124516903heaped
helipad1344723helipad
helped124714153helped
heptad1237273heptad
hexad164910623he_xad
heyday1635143heyday
hyped145313333_hyped
jeeped16469843jeeped
jehad1637683je_had
jeopard1744113jeopard
kalpa114512193kalpa_
kalpac14428223kalpac
kalpak11437243kalpak
kalpas124112943kalpas
kapa106021293k_apa_
kapas116021733k_apas
kappa13469743kappa_
kappas144410363kappas
kayak1138363kay_ak
kayoed14416903kayoed
kea76540913ke__a_
keas86337093ke__as
kebab134312003ke_bab
kebar115113533ke_bar
keblah1545313keblah
kecked125113173kecked
keddah1534273keddah
kedged13439753kedged
keeked104810123keeked
keeled114414273keeled
keened114013633keened
keep106329823keep__
keeper123811923keeper
keeps116020283keep_s
kegged13469263kegged
keloid11812623keloid
kelp105322803kelp__
kelpie12308613kelpie
kelps115116423kelp_s
kelpy145110683kelp_y
kemp126418763kemp__
kemps135012523kemp_s
kempt134318463kemp_t
kenaf12316033ke_naf
kenned114411273kenned
kep96437203ke_p__
kepi105315633ke_p_i
kepis115313363ke_pis
keppen14346573keppen
keps106027303ke_p_s
kept106232943ke_p_t
kerbed13339703kerbed
kerfed14358233kerfed
kerned114112933kerned
kewpie15465413kewpie
key105833333key___
keyboard1844503keyboard
keycards1843063keycards
keying1438043keying
keys116322163key__s
keyset13411533keyset
keyways2043373keyways
keyword1844563keyword
kipped153114573kipped
knead10429663k_nead
kneepads15102253kneepads
kneepan1372623kneepan
koppa13397293koppa_
koppas14407603koppas
kyak105213633k_y_ak
kyar116916843k_y_ar
kyat116025523k_y_at
lampad114510033lampad
lead56038853le__ad
leaped94317773leaped
leopard1045293leopard
mead75531603me__ad
mediad104313713mediad
menad85918983me_nad
pad68057323___pad
peeped113915393peeped
pentad9313763pentad
pepped103113403pepped
read55942533re__ad
reaped94122453reaped
reclad9311873reclad
reload7413893reload
repaid94716323re_paid
repand95316063re_pand
repay104818453re_pay
repped114616723repped
reread71715433reread
respade1039573respade
retyped13367303retyped
reynard1135123reynard
secpar1037923secpar
seeped94317523seeped
sepal77723003se_pal
skelped1435203skelped
temped113912893temped
teopan839353teopan
tepa66021683te_pa_
tepal76319583te_pal
tepas76521683te_pas
tepid8314313te_pid
tetrad73612053tetrad
typal105311153_typal
typed115815453_typed
vespid1246083vespid
yelped12439363yelped

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.376475242.0
2DLD Change Limit1127161405.50020493.8
3Display Results1401400.0463043.5
 (SQL Overall)1786911405.92230174.1
 
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.