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 “shlepped” 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
shlepped163364(None) 
schlepped1942231schlepped
shipped153312102sh_ipped
shlepp13366192shlepp__
shlepps14394832shlepp_s
shlumped1643442shlumped
shopped153512212sh_opped
slapped123511852s_lapped
slipped124711742s_lipped
slopped123511442s_lopped
stepped123210052s_tepped
ashlered1244623ashle_red
beleaped1336103beleaped
bleeped12287273_bleeped
blipped14377193_blipped
chapped172711443ch_apped
cheeped153410593ch_eeped
cheliped1635043cheliped
chipped174110813ch_ipped
chopped174511003ch_opped
clapped143511173_clapped
cleped115114113_cle_ped
clipped14439833_clipped
clopped143611523_clopped
flapped15328253_flapped
flipped15358513_flipped
flopped15338763_flopped
glopped13347613_glopped
happed144820103_h_apped
heaped124516903_h_eaped
helped124714153_h_elped
hepper133412663_h_epper
hipped144317693_h_ipped
hopped144318113_h_opped
kepped15309543__kepped
lapped114320033__lapped
leaped94317773__leaped
lipped114419543__lipped
lopped114218623__lopped
pepped103113403__pepped
plopped11288773_plopped
prepped11329903_prepped
repped114616723__repped
sapped114422013s__apped
schlepp1662953schlepp__
schlepps1762563schlepp_s
schlumped1941953schlumped
scrapped1556533scrapped
seeped94317523s__eeped
selected1159783selected
shaped125020103sh__aped
sharped134112053sh_arped
sheafed14388973sh_eafed
sheared114516003sh_eared
sheaved143411633sh_eaved
shedded13419063sh_edded
sheened113511703sh_eened
sheephead1863893sheephead
sheepmen1544643sheepmen
sheered113515453sh_eered
sheeted113813043sh_eeted
sheetfed1544143sheetfed
shelled113815093sh_elled
shelved14379933sh_elved
shepherd1744373sh_epherd
shewed134716183sh_e_wed
shielded1334393shielded
shippen14298863sh_ippen
shipper143514043sh_ipper
shlemiel1393823shlemiel
shlep104914833shle_p__
shlepping1733393shlepping
shleps114710333shle_p_s
shoppe133110323sh_oppe_
shopper143312633sh_opper
shoppes143411403sh_oppes
shredded1444063shredded
shrewed14589853shre_wed
shrimped1634213shrimped
silenced1136273silenced
sipped113720633s__ipped
skelped1435203s_kelped
skipped16358413s_kipped
sklented1335053sklented
slapper113512473s_lapper
sleaved113611133s_leaved
sledded10378873s_ledded
sledged103610333s_ledged
sleeked123510883s_leeked
sleeper93211563s_leeper
sleeted83113223s_leeted
sleeved11419913s_leeved
slewed104815523s_le_wed
sliped95417063s_l_iped
slipper113712983s_lipper
sloped94216853s_l_oped
slumped123710153s_lumped
slurped10368753s_lurped
snapped124611203s_napped
sneaped10338813s_neaped
snipped123510043s_nipped
sopped114819903s__opped
steeped103412283s_teeped
steepled1135903steepled
steppe10319873s_teppe_
stepper113010853s_tepper
steppes113110693s_teppes
stopped124512203s_topped
strapped1357823strapped
stripped1357093stripped
stropped1367343stropped
supped114415703s__upped
swapped15429143s_wapped
swopped15437673s_wopped
threaped1454863threaped
threeped1454373threeped
upleaped1334333upleaped
whapped18367573wh_apped
wheeped16387503wh_eeped
wheepled1733293wheepled
whelped16355633wh_elped
whipped18379333wh_ipped
whopped18358003wh_opped
whupped18365413wh_upped
ycleped1543393ycle_ped

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621257.84318636.0
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.31221498.0
 
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.