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

159 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
yclept133601(None) 
clept95725771_clept
accept123210622accept
clapt98027172_clapt
cleat76335062_cleat
cleft106222852_cleft
clepe94617382_clepe
clipt96324272_clipt
crept95125892_crept
lept66440882__lept
slept75728102_slept
ycleped1543392ycleped
ablest84721833ablest
acaleph1453443acaleph
accent105116263accent
accepts13356353accepts
adept81219643_adept
aglet65534143agle_t
aleph10311393_aleph
alert54740653_alert
beleapt11310253beleapt
bewept13410323bewept
bleat75737003_bleat
blent76230953_blent
blest76431723_blest
blet66247673_ble_t
celt65646713_c_elt
cent67451013_c_ent
cep75736333_c_ep_
cepe84926653_c_epe
ceps86125953_c_eps
chapt125827643_chapt
cheat105732453_cheat
chert105232103_chert
chest104926143_chest
clap86429043_clap_
claps95626183_claps
claspt104513413_claspt
clast76030583_clast
clean75420413_clean
clear76219053_clear
cleats84919313_cleats
cleek115514913_cleek
clef97028183_cle_f
clefs106616243_clefs
clefts114610163_clefts
cleped115114113_cleped
clepes104214623_clepes
clerk115812453_clerk
clew95520573_cle_w
clews105516333_clews
client8316343_client
clift106422193_clift
clip86924003_clip_
clips96018303_clips
cloot76127053_cloot
clop86929893_clop_
clops95924853_clops
clot66542423_cl_ot
clout75330463_clout
coapt96131533_coapt
coempt12311033_coempt
compt116328223_compt
coopt95929853_coopt
crepe95520723_crepe
crepy124812703_crepy
crest74632693_crest
crypt123715233_crypt
culet76040343cule_t
cycle1239523cycle__
cycled1436543cycle_d
cycler1335913cycle_r
cyclers1435873cyclers
cyclery1763493cyclery
cycles1339303cycle_s
cyclist1438853cyclist
cyclops1635383cyclops
eclat7523603ecl_at
elect74327033_elect
except1797653except
eyelet9514533eyele_t
filet85540163file_t
fleet85932333_fleet
gleet65532343_gleet
halest94823273halest
iciest82914743iciest
idlest74014863idlest
illest63615723illest
incept102712753incept
inept73622153_inept
inlet53732403inle_t
islet54527553isle_t
julep14310533julep_
juleps1535623juleps
kelep116014563kelep_
keleps12478813keleps
kept106232943__kept
klepht1535043_klepht
klepto1244453_klepto
leapt75027473__leapt
leet45957903__leet
left76340483__left
lent46360533__lent
lepta75714393__lepta
lest46956323__lest
let36481473__le_t
molest85022743molest
ocelot8813383ocelot
octet7324063octe_t
owlet83324463owle_t
palest83926223palest
palet74650803pale_t
pleat74734473_pleat
recept103319073recept
relent64431853relent
relet54749823rele_t
salep77022953salep_
saleps85014903saleps
scent75831623sc_ent
schlep1347093schlep_
schlepp1662953schlepp
schleps1445483schleps
sclera838893sclera
script105717903script
sculpt104412693sculpt
select82621173select
sept65844363__sept
shlep104914833shlep_
shlepp13366193shlepp
shleps114710333shleps
silent64125843silent
sklent103614353sklent
sleet55639133_sleet
slipt76627483_slipt
splent84720193splent
swept105720603_swept
talent6323323talent
uncleft1257493uncleft
unkept123710873unkept
unlet54133333unle_t
unwept11389813unwept
upleapt11116863upleapt
valet84337873vale_t
vilest9416843vilest
wept95635053__wept
yarest95018913yarest
yclad11246383ycl_ad
yelp95621353yel_p_
yelped12439363yelped
yelper11458783yelper
yelps105712993yel_ps
yep86638963y__ep_
yeps95924403y__eps
yet66960693y__e_t
yett76434493y__ett
ylem9217893y_le_m
ylems1039263y_lems
yule75725143yule__
yules84521583yule_s

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 Limit1127161594.68624053.8
3Display Results1591590.0463456.5
 (SQL Overall)1786911595.10834982.6
 
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.