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

218 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
usurped103515(None) 
usurper934351usurper
burped116215502_burped
slurped10368752slurped
supped114415702_supped
surfed103814462_surfed
surged84118882_surged
unurged939142unurged
upsurged12124042upsurged
urped84615282__urped
usurer638102usur_er
usuries7510632usuries
usurp7106902usurp__
usurpers1033742usurpers
usurps8105072usurp_s
assured858373assur_ed
augured987193augur_ed
blurbed12337613blurbed
blurred10427803blurred
blurted10399783blurted
bumped134414003_bumped
buried94822373_buried
burked135220883_burked
burled94825383_burled
burned95818963_burned
burred95820723_burred
carped115923763_carped
chirped15379783chirped
chumped17379493chumped
churned13358373churned
churred13409173churred
clumped143610663clumped
couped115019313cou_ped
coursed104113603coursed
courted103514923courted
crumped144311223crumped
cupped134413983_cupped
curbed114615873_curbed
curded104217163_curded
cured85932133_cur_ed
curled95021653_curled
curred94319263_curred
cursed94321253_cursed
curved124815223_curved
cusped114312043_cusped
dumped123814493_dumped
duped95118323_du_ped
dupped124411643_dupped
dured75025403_dur_ed
durned84113173_durned
ensured83512943ensur_ed
enured73315333enur_ed
escaped12388853escaped
escarped1355163escarped
flumped15377713flumped
furled104717053_furled
furred104514433_furred
grumped13337333grumped
gulped104610373_gulped
gurged95513363_gurged
harped124418403_harped
humped144015243_humped
hurled104617453_hurled
insured83714253insur_ed
inured73114813inur_ed
inurned8328053inurned
jauped16457903jau_ped
jumped183511553_jumped
juried144212443_juried
knurled1244653knurled
louped95316383lou_ped
loured74617403lour_ed
lumped114216963_lumped
lured65427493_lur_ed
lurked114511973_lurked
lustred8359053lustr_ed
mourned1037763mourned
mumped133813163_mumped
mured85726703_mur_ed
nurled74016233_nurled
nursed74514663_nursed
plumped14318643plumped
poured95116743pour_ed
pulped114612533_pulped
pumped133915563_pumped
pupped105013273_pupped
pureed95017813_pureed
purged104918263_purged
purled94520753_purled
purpled12299783_purpled
purred94218073_purred
pursed95220883_pursed
resurged1038623resurged
rouped95717353rou_ped
sapped114422013_sapped
scaped115519553_scaped
scarped124314403scarped
scoped115116653_scoped
scraped124313133_scraped
screed95718933_screed
scried95817303_scried
sculped12398253sculped
seeped94317523_seeped
sered65737293_ser_ed
serged84118773_serged
served104616813_served
shaped125020103_shaped
sharped134112053sharped
shred98125613_shr_ed
siped84927683_s_iped
sipped113720633_sipped
sired66134283_sir_ed
siruped1036013_siruped
sliped95417063_sliped
sloped94216853_sloped
slumped123710153slumped
slurred8359193slurred
sniped94913483_sniped
soaped95817973_soaped
sopped114819903_sopped
sorbed94916523_sorbed
sored66141783_sor_ed
sorned74820043_sorned
sorted74523713_sorted
souped95017673_souped
sourced1038453sourced
soured74921863sour_ed
sped76031493_s__ped
spurned10339263spurned
spurred103610623spurred
spurted103111973spurted
stiped94517073_stiped
stoped94721013_stoped
striped105214363_striped
stumped124210153stumped
subbed114116673_subbed
suburbed1345143suburbed
sucked134120493_sucked
sudsed83911373_sudsed
sued56537933_su__ed
sueded84014633_sueded
sughed113610203_sughed
suited74019423_suited
sulked114314703_sulked
summed114014043_summed
sunned74216323_sunned
supe65932763_su_pe_
super74924483_su_per
supes75628303_su_pes
supper104115433_supper
suppled1248463_suppled
surd56433813_sur__d
sure45447413_sur_e_
surer54833103_sur_er
surfer93515883_surfer
surge65027693_surge_
surger74320093_surger
surges73924593_surges
surrey94414583_surrey
survey124111673_survey
suspend1036013_suspend
sussed75015533_sussed
sutured8310373sutur_ed
swiped123811093_swiped
syruped1334543_syruped
thumped15387413thumped
toured74216153tour_ed
trumped12439713trumped
tumped114216233_tumped
tupped114013233_tupped
turfed103110963_turfed
turned73914473_turned
umped104717273__umped
unarmed101811923unarmed
unbred92613303unbr_ed
unburied11208513unburied
unburned11227413unburned
uncurbed1346903uncurbed
uncured10513233uncur_ed
uncurled1168963uncurled
uncursed1148973uncursed
undraped1239393undraped
undried92314613undried
unfreed11510123unfreed
unfurled1277203unfurled
unhoped13249353unhoped
unpurged1236293unpurged
unroped102812103unroped
unruled8311373unruled
unserved12410233unserved
unshaped14148443unshaped
unsorted9312513unsorted
unsourced1244833unsourced
unsoured9310063unsour_ed
unstriped1246303unstriped
unsuited9310793unsuited
unsure62815413unsur_e_
untried82615853untried
unturned9228563unturned
unused72012883unu_sed
unwarped1436873unwarped
upcurled1393783upcurled
upcurved16142993upcurved
updried11226473updried
upped103715163__upped
upsurge10134333upsurge_
upsurges11144803upsurges
upturned11214013upturned
urged75316033__urged
used55722823us___ed
ushered1139153ushered
usurers766363usurers
usurping1134163usurping
usury887623usur__y
warped124816413_warped
whumped18335633whumped
whupped18365413whupped
yauped12408333yau_ped

Search took 8 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 Limit1340272187.00019146.7
3Display Results2182180.0802725.0
 (SQL Overall)1786912187.50023825.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.