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

195 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
keypal153489(None) 
keypad1633821keypad
keypals1634351keypals
keypads1743342keypads
keyway1943822keyway
sepal77723002se_pal
tepal76319582te_pal
typal105311152_typal
aecial84817313aecial
aerial64625713aerial
appal95315223_appal
bedpan1137583bedpan
benzal1739643benzal
carpal103716253carpal
cecal94619113ce_cal
cental84420963cental
cercal10314123cercal
cereal8315833cereal
clypeal1443513clypeal
copal95621783_copal
cryptal1445683cryptal
cuspal1037883cuspal
deal56347413de__al
decal85523233de_cal
dedal75719023de_dal
denial74720513denial
dental74319173dental
dermal93614343dermal
ectypal1442773ectypal
egal55119433_e_gal
empale102611263_empale
equal1449823_equal
espial839543_espial
expat14313813_expat
expel1448233_expel
eyas76427433_ey_as
eyra76217553_eyra_
eyras84715923_eyras
feal713940423fe__al
fecal105119213fe_cal
fecial114714623fecial
feral85424653fe_ral
ferial94621253ferial
festal94213563festal
fetal85623373fe_tal
fetial95716193fetial
feudal1037683feudal
frypan1434543frypan
gayal9312713gay_al
genial74917613genial
gyral94412783_gyral
heal75645693he__al
hemal104419803he_mal
herbal112513493herbal
heyday1635143heyday
hyetal1236543hyetal
hyphal1736413_hyphal
kalpa114512193kalpa_
kalpac14428223kalpac
kalpak11437243kalpak
kalpas124112943kalpas
kapa106021293k_apa_
kapas116021733k_apas
kappa13469743kappa_
kappas144410363kappas
kayak1138363kay_ak
kea76540913ke__a_
keas86337093ke__as
kebab134312003ke_bab
kebar115113533ke_bar
keblah1545313keblah
keddah1534273keddah
keel85729473ke__el
keep106329823keep__
keepable1635323keepable
keeper123811923keeper
keeps116020283keep_s
kelp105322803kelp__
kelped13449553kelped
kelpie12308613kelpie
kelps115116423kelp_s
kelpy145110683kelp_y
kemp126418763kemp__
kemps135012523kemp_s
kempt134318463kemp_t
kenaf12316033ke_naf
kennel10369223kennel
kep96437203ke_p__
kepi105315633ke_p_i
kepis115313363ke_pis
kepped15309543kepped
keppen14346573keppen
keps106027303ke_p_s
kept106232943ke_p_t
kernel104010593kernel
ketol95414003ke_tol
kevel124213103ke_vel
kevil12399863ke_vil
kewpie15465413kewpie
key105833333key___
keycard1743663keycard
keyed1369393key_ed
keyhole1764433keyhole
keying1438043keying
keys116322163key__s
keyset13411533keyset
keyways2043373keyways
kneepad1462373kneepad
kneepan1372623kneepan
koppa13397293koppa_
koppas14407603koppas
kraal94511823k_raal
kyak105213633k_y_ak
kyar116916843k_y_ar
kyat116025523k_y_at
leal46043273le__al
legal65715943le_gal
lethal939803lethal
loyal84513483loy_al
meal65643173me__al
meatal84114733meatal
medal86221333me_dal
medial93819863medial
menial84223033menial
mensal84615663mensal
mental84521603mental
mescal104113493mescal
mesial84818083mesial
metal75427383me_tal
mezcal19367853mezcal
neural6311993neural
nopal75517103_nopal
oedipal1045173oedipal
opal66923523__opal
pal56761673___pal
palpal104112053palpal
papal95820673_papal
peal68648103pe__al
pedal86022503pe_dal
peepul1035783peepul
penal75228373pe_nal
penial84120893penial
pepla9312863pe_pla
petal76526893pe_tal
peyotl1146233peyotl
peytral1287503peytral
pipal95118353_pipal
pulpal10408453pulpal
pupal97616873_pupal
real45750293re__al
recoal84117973recoal
rectal84418133rectal
redial74923113redial
regal65023793re_gal
regnal74812933regnal
renal55929503re_nal
rental63922023rental
repay104818453re_pay
repeal84718283repeal
repel74921403re_pel
reseal64819643reseal
retial64724993retial
retral64419743retral
reveal94115053reveal
riyal84413433riy_al
royal85014703roy_al
seal45654373se__al
secpar1037923secpar
sendal73314993sendal
sepals85217373se_pals
septal84513383septal
seral56336383se_ral
serial64625863serial
serval93913413serval
setal56430903se_tal
sexual1338413sexual
teal45546503te__al
tectal83713253tectal
telial65815363telial
teopan839353teopan
tepa66021683te_pa_
tepals85415043te_pals
tepas76521683te_pas
tergal72912833tergal
veal76936813ve__al
veinal93812963veinal
venal85523213ve_nal
venial94218283venial
verbal112513663verbal
vernal93514213vernal
versal93013753versal
vestal94615573vestal
weal75838683we__al
xenial133414903xenial
zeal135530333ze__al

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.373479064.3
2DLD Change Limit1127161955.01622471.3
3Display Results1951950.0464239.1
 (SQL Overall)1786911955.43532877.8
 
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.