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

170 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
upleaps118523(None) 
upheaps1494231upheaps
upleap10106841upleap_
upleapt11116861upleapt
beleaps1138052beleaps
leaps75522932__leaps
outleaps10237072outleaps
pleads94613952_pleads
pleas75627032_plea_s
pleats85218592_pleats
unleads8228622unleads
upbears1195422upbears
upbeats1195732upbeats
upheap13105212upheap_
upkeeps1532192upkeeps
upleaped1334332upleaped
uploads10266502uploads
uprears9107492uprears
uptears9106452uptears
apneas83211383apnea_s
appeals11378673appeals
appears11308953appears
beleap10410283beleap_
beleapt11310253beleapt
bleaks125112433_bleaks
blears85116453_blears
bleats85518613_bleats
bleeps10499103_bleeps
burlaps1156253burl_aps
cheaps134613683_cheaps
claps95626183_cl_aps
cleans85817053_cleans
clears84116563_clears
cleats84919313_cleats
coleads102911423coleads
deleads9379703deleads
duplexes1844053duplexes
eupneas935233eupnea_s
flaps105621383_fl_aps
fleams115011943_fleams
fleas86423663_flea_s
galeas74618513galea_s
gelcaps1235203gelcaps
gleams94812253_gleams
gleans75014743_gleans
heaps105223223__heaps
impleads13294593impleads
jalaps15299183jal_aps
juleps1535623jule_ps
keleps12478813kele_ps
laps66848873__l_aps
leads66028493__leads
leafs85721183__leafs
leaks95923913__leaks
leans55536253__leans
leap66032683__leap_
leapt75027473__leapt
lears55938733__lears
leas45954183__lea_s
neaps75618323__neaps
outleads9278763outleads
outleap9298293outleap_
outleapt10318153outleapt
paeans85118263_paeans
paps86443453_p__aps
peags86122843_p_eags
peaks114825623_p_eaks
peals75235493_p_eals
peans75437643_p_eans
pears75138613_p_ears
peas65755063_p_ea_s
peats76140193_p_eats
peeps95822363_p_eeps
peps85134513_p_e_ps
perps95521483_p_erps
pileups11365433pileups
plans75731273_pl_ans
plats75531373_pl_ats
plays106320773_pl_ays
plea66830603_plea__
pleach134211243_pleach
plead85818463_plea_d
please84315733_please
pleases94515483_pleases
pleat74734473_plea_t
plebes104313623_plebes
plebs95814583_ple_bs
pleiads1045223_pleiads
pleons84213343_pleons
plews105415353_ple_ws
plexes155313543_plexes
plexus15377283_plexus
plops95920333_pl_ops
plumps124612613_plumps
preamps1336613_preamps
preops104911943_preops
preps96220693_pre_ps
pulers83820283pule_rs
pules74538813pule__s
pullups1134233pullups
pulps95116483pul__ps
pulsars9358913pulsars
queleas1636723quelea_s
reaps75626193__reaps
repleads11357213repleads
saleps85014903sale_ps
shlepps14394833shlepps
shleps114710333shle_ps
slaps76025713_sl_aps
sleeps83913323_sleeps
sneaps84510863_sneaps
speaks125114583sp_eaks
speans85417143sp_eans
spears84019473sp_ears
splats84817303spl_ats
splays114910873spl_ays
spleens937103spleens
splents93912133splents
spreads1039763spreads
threaps12488643threaps
uhlans937573uhl_ans
ulans54921303u_l_ans
ulemas888963u_lemas
ulnas55716533u_lna_s
ulvas84511503u_lva_s
unbears998043unbears
uncaps1039813u_ncaps
unlays93810493unl_ays
unlead73312373unlea_d
unlearn735953unlearn
unlearns844453unlearns
unleash1034963unleash
unless62413073unle_ss
unloads8278523unloads
unseals73212573unseals
unseams9338913unseams
unseats73012853unseats
unsnaps935423unsnaps
unwraps1255513unwraps
upas68322383up__a_s
upbear1096493upbea_r
upbeat10911513upbea_t
upends9438763up_ends
upheaped1633643upheaped
upheave1544023upheave
upheaves1643913upheaves
upkeep1434143upkeep_
upland938863upl_and
uplands1036943uplands
upleaping1434363upleaping
uplifts12424773uplifts
uplinks13345613uplinks
upload9257783uploa_d
uppers102912293uppe_rs
upprops1044223upprops
upreach1444693upreach
uprear8168793uprea_r
uproars986453uproars
upsends10265293upsends
upsets8409683upse_ts
upsoars985413upsoars
upsteps1133743upsteps
upsweeps1541773upsweeps
uptear896783uptea_r
uptempo1342413uptempo
uptempos1441923uptempos
upwells12244303upwells
ureas55826013u_rea_s
usneas638333usnea_s
uveas84912283u_vea_s

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.420425454.8
2DLD Change Limit1340271706.14321817.8
3Display Results1701700.0602833.3
 (SQL Overall)1786911706.62326980.4
 
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.