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

125 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
keypals163435(None) 
keypads1743341keypads
keypal1534891keypal_
keypad1633822keypa_d
keyways2043372keyways
sepals85217372se_pals
tepals85415042te_pals
aerials74017553aerials
appals104812943_appals
bedpans1237173bedpans
bypass1345043_bypass
carpals113414623carpals
centals94317053centals
cereals9313173cereals
copals105018943_copals
deals65435343de__als
decals93717713de_cals
denials84114133denials
dentals83915393dentals
empale102611263_empale
empales112411433_empales
equals1538693_equals
espials937093_espials
expats1537683_expats
expels1547173_expels
eyas76427433_ey_a_s
eyass84410783_ey_ass
eyras84715923_eyra_s
fecials123510333fecials
ferals94216643fe_rals
fetials103711743fetials
frypans1544053frypans
gayals1039513gay_als
heals85733453he__als
herbals122710603herbals
heydays1734143heydays
kalpacs15327133kalpacs
kalpaks12366163kalpaks
kalpas124112943kalpa_s
kapas116021733k_apa_s
kappas144410363kappa_s
kayaks1236333kay_aks
keas86337093ke__a_s
kebabs14418513ke_babs
kebars124112493ke_bars
keblahs1634563keblahs
keddahs1642923keddahs
keels94622413ke__els
keepable1635323keepable
keepers133410983keepers
keeps116020283keep__s
kelpies13289903kelpies
kelps115116423kelp__s
kemps135012523kemp__s
kenafs1337113ke_nafs
kennels11387193kennels
kepis115313363ke_p_is
keps106027303ke_p__s
kernels11417953kernels
ketols104210763ke_tols
kevels134410713ke_vels
kevils13358333ke_vils
kewpies16246923kewpies
keycard1743663keycard
keycards1843063keycards
keyhole1764433keyhole
keyholes1844593keyholes
keyless1436163keyless
keys116322163key___s
keysets1434343keysets
keyway1943823keywa_y
kneepads15102253kneepads
kneepans1462733kneepans
koppas14407603koppa_s
kraals10378433k_raals
kyaks11459163k_y_aks
kyars124813963k_y_ars
kyats125012443k_y_ats
legals73412733le_gals
lethals1038113lethals
meals75933373me__als
medals94218053me_dals
medials103914733medials
menials94015683menials
mescals112911553mescals
metals84520883me_tals
mezcals20246533mezcals
nopals84914023_nopals
opals75718353__opals
pals66951353___pals
peals75235493pe__als
pedals94316033pe_dals
peepuls1134923peepuls
petals84719813pe_tals
peyotls1233633peyotls
peytrals1355493peytrals
pipals104213643_pipals
reals55038653re__als
recoals94214623recoals
redials84416883redials
rentals74017473rentals
repass84114703re_pass
repays113813973re_pays
repeals94014523repeals
repels84318763re_pels
reseals73917663reseals
reveals103812723reveals
riyals94111083riy_als
royals93711263roy_als
seals54839693se__als
secpars1138413secpars
sendals81912263sendals
sepal77723003se_pal_
serials73919743serials
servals103410743servals
teals56234133te__als
teopans939203teopans
tepal76319583te_pal_
tepas76521683te_pa_s
typal105311153_typal_
veals84926193ve__als
verbals121910743verbals
vestals104612333vestals
weals85428743we__als
zeals145320853ze__als

Search took 7 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 Limit1340271256.03322215.6
3Display Results1251250.0462717.4
 (SQL Overall)1786911256.48527554.5
 
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.