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

383 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
usurp710690(None) 
usurps8105071usurps
usury887621usury
burp85028882_burp
slurp74014982slurp
sump86331532_sump
sup57041942_su_p
sura45740292_sura
surd56433812_surd
sure45447412_sure
surf76039312_surf
unsure62815412unsure
urp56426392__urp
user45023002user_
users55817572users
usual5310182usual
usurer638102usurer
usurped1035152usurped
usurper934352usurper
absurd935903absurd
asp57235343as__p
assure6610773assure
auburn836213auburn
augur64311213augur_
augurs7399963augurs
augury10366663augury
aura45836253_aura
ausubo853653ausubo
azure14911483azure
blur66020533blur_
blurb95214903blurb
blurs74619083blurs
blurt77625623blurt
bourg84113843bourg
bourn75518483bourn
bump106228243_bump
bur55744693_bur_
bura66139533_bura
burb85334673_burb
burd75534263_burd
burg74930363_burg
burl64937183_burl
burn65636423_burn
burps94220173_burps
burr65631233_burr
burs65847423_burs
bury95633593_bury
carp85139813_carp
cesura838763cesura
chirp124717163chirp
chump145315443chump
churl105913883churl
churn105113103churn
churr104512853churr
clump115517453clump
coup86729793cou_p
court75532763court
crump115616423crump
crura7312583crura
cup76738243_cu_p
cur56841983_cur_
curb86732223_curb
curd77634983_curd
cure66149123_cure
curf97538783_curf
curl66035053_curl
curn66731883_curn
curr65429653_curr
curs65645543_curs
curt67051713_curt
cusp86021063_cusp
cutup9410093cutu_p
dorp76028053_dorp
dour56330433dour_
doura66518663doura
dump95927093_dump
dup67637883_du_p
dura55232113_dura
dure56341813_dure
durn56127623_durn
duro56228023_duro
durr55624353_durr
dustup935363dustup
ensure63416003ensure
enure53520223enure
equip16467263equip
escarp10449003escarp
estop74312103estop
euro45325273_euro
exurb1457703exurb
flump124614723flump
four76226863four_
fours85521493fours
frump126912563frump
fur66637323_fur_
furl77030883_furl
furs76735043_furs
fury107727973_fury
fusuma1134503fusuma
future939563future
gaur56723353gaur_
gaurs66317993gaurs
gorp75625903_gorp
gourd71011903gourd
grump105115313grump
gulp75521363_gulp
guru54623913_guru
harp96134283_harp
hour75827313hour_
houri85915233houri
hours85422383hours
hump116228723_hump
hup86437813_hu_p
hurl76029933_hurl
hurt77142573_hurt
insure63416603insure
inure54119053inure
inurn53712863inurn
jaup135316423jau_p
jump156621723_jump
jura116024893_jura
jury146719593_jury
kauri93811843kauri
kaury12429763kaury
knur85311973knur_
knurl9398913knurl
knurs94511153knurs
kuru85521803_kuru
laura54116203laura
loup66028433lou_p
lour45430683lour_
lours55125293lours
loury85716753loury
lump86531703_lump
lure45142463_lure
lurk86624163_lurk
lustra6358893lustra
lustre64011683lustre
lusus54813873lusu_s
luxury1642543luxury
mourn77215013mourn
mump105425723_mump
mura65633293_mura
mure65941333_mure
murk105527253_murk
murr65225133_murr
muser76024123muser_
musers84719093musers
nurd56224343_nurd
nurl45327243_nurl
osar46820953osar_
our36042893_our_
ours47237563_ours
perp89029893_perp
plump115315263plump
pour611527473pour_
pours74623183pours
pulp84825353_pulp
pump105726853_pump
pup76339883_pu_p
pur56840553_pur_
pure65543333_pure
puri65931443_puri
purl65631423_purl
purr64925813_purr
purs65641043_purs
pushup1335273pushup
quip154818623_quip
rasure6311423rasure
roup66627693rou_p
rump86729083_rump
salp64534093_salp
samp85733593_samp
sap56463233_s_ap
sard55344243_sard
sari45444043_sari
sark84938973_sark
saury84317223saury
scarp95724103scarp
scop85925523_scop
scrap97120403_scrap
scrip96619193_scrip
scry96017763_scry
sculp95314843sculp
scup84822383_scup
scurf104719323scurf
seep66540343_seep
ser36752403_ser_
sera46141393_sera
sere46153473_sere
serf76340113_serf
sers45746653_sers
sharp104922533sharp
ship95228233_ship
shop95629833_shop
shri76021693_shri
simp85228773_simp
sip57656013_s_ip
sir35746673_sir_
sire46150413_sire
sirs44338333_sirs
sirup74014913_sirup
skep105219353_skep
skip105421743_skip
slap66434043_slap
slip67031733_slip
slop66533873_slop
slump94816633slump
slur45525153slur_
slurb74116323slurb
slurps84410003slurps
slurs54123373slurs
snap65727033_snap
snip66424653_snip
soap65831133_soap
sop57557863_s_op
sora45746913_sora
sorb68333043_sorb
sord56237203_sord
sore47059533_sore
sori46039833_sori
sorn46641063_sorn
sort46264813_sort
soup66232913_soup
sour45935893sour_
sours55230503sours
spry96819123_spry
spur65321193spur_
spurn74815453spurn
spurs74621523spurs
spurt77227983spurt
sri35634003_s_ri
step67126293_step
stirp76815503stirp
stop66532033_stop
strap77925263_strap
strep77120853_strep
strip77524333_strip
strop77422243_strop
stump94616463stump
sturt56028963sturt
sub55445553_su_b
suba64926603_suba
subs66037123_subs
suburb1037163suburb
such96424813_such
suck106131733_suck
sucre75019103sucre
sudd64719773_sudd
suds56135293_suds
sue35651463_su_e
sued56537933_sued
suer45334033_suer
suers55128483suers
sues46247653_sues
suet46754823_suet
sugh86423443_sugh
suit45649873_suit
suk75632973_su_k
suks85927123_suks
sulk85326653_sulk
sulu45128423_sulu
sum56346013_su_m
sumo67326313_sumo
sumps95023433_sumps
sums65837583_sums
sun37149033_su_n
sung55832173_sung
sunk85031813_sunk
sunn45423593_sunn
suns45841903_suns
sunup7313053sunup
supe65932763_supe
supra73614253supra
sups64834433_sups
suq126228993_su_q
suqs134319653_suqs
surah86823253_surah
sural55931263_sural
suras55336323_suras
surds65624663_surds
surer54833093_surer
surfs85022543_surfs
surfy115319473_surfy
surge65027693_surge
surgy95118523_surgy
surly85124423_surly
surra55521343surra
suss45229303_suss
sutra54217933sutra
suture6313203suture
swap95925433_swap
swop95120503_swop
syrup103010963_syrup
tarp66936413_tarp
thorp104414263thorp
thump126211573thump
thurl84912683thurl
tour45530373tour_
tours55325863tours
trump95615123trump
tsar47819803tsar_
tsars56717103tsars
tsuba745563tsuba
tsuris62710203tsuris
tump85927033_tump
tup56037543_tu_p
turd56027623_turd
turf75334053_turf
turk86125863_turk
turn46330383_turn
turps74918733_turps
tussur6357293tussur_
tussurs7356373tussurs
twerp10398413twerp
twirp10468943twirp
ultra539363ultra
ulu36028703ulu__
ulus45622563ulu_s
umbra948503umbra
ump76130443__ump
unarm7314453unarm
unary8315993unary
uncap9312283uncap
uncurb1037043uncurb
uncurl839413uncurl
unfurl937953unfurl
unhip10178823unhip
unhurt9311253unhurt
unpure82911533unpure
unrip72012863unrip
unsharp1235543unsharp
unship1148033unship
unsnap836203unsnap
unstep839223unstep
unstop837473unstop
unstrap946783unstrap
unsung736983unsung
unsunk1036333unsunk
unwrap11126323unwrap
unzip16207623unzip
up47832823__u_p
upcurl1034963upcurl
updry1135483updry
upprop944093upprop
upstep1035503upstep
upsurge10134333upsurge
upturn8286243upturn
urare56322553urare
urari54619963urari
urb55731103__urb
urd46427043__urd
urn35731463__urn
urps66920473__urps
urus46426133uru_s
us26937433us___
usage6410213usage
use36835163us__e
used55722823us_ed
uses44931113us_es
usher84517763usher
ushers94415533ushers
using66317963using
usnea539393usnea
usque14137733usque
usques15126803usques
usuals637783usuals
usurers766363usurers
usuries7510633usuries
usurpers1033733usurpers
usurping1134163usurping
uteri51012983uteri
uvula845153uvula
warp95635003_warp
waur76819903waur_
whump154910043whump
whup125714163whu_p
yaup96618483yau_p
your78623433your_
yourn87512773yourn
yours85217873yours
yup86031703_yu_p
yurt76435043_yurt

Search took 5 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 Filter178691836670.1231452772.4
2DLD Change Limit836673834.08020506.6
3Display Results3833830.1103481.8
 (SQL Overall)1786913834.31341430.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.