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

532 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
usury88762(None) 
usurp7106901usurp
augury10366662augury
bury95633592_bury
fury107727972_fury
jury146719592_jury
kaury12429762kaury
loury85716752loury
luxury1642542luxury
saury84317222saury
scry96017762_scry
spry96819122_spry
sura45740292_sura
surd56433812_surd
sure45447412_sure
surf76039312_surf
surfy115319472_surfy
surgy95118522_surgy
surly85124422_surly
unary8315992unary
unsure62815412unsure
updry1135482updry
user45023002user_
users55817572users
usual5310182usual
usurer638102usurer
usurps8105072usurps
absurd935903absurd
aery77231683_aery
airy75734153_airy
alary86123443alary
ambry123512093ambry
angry9310863angry
apery106517903apery
ashy107717353as_hy
assay8710283assay
assure6610773assure
astray95615543astray
auburn836213auburn
augur64311213augur_
augurs7399963augurs
aura45836253_aura
ausubo853653ausubo
awry107619683_awry
azure14911483azure
beery105220123beery
berry104521763berry
bluey104817053bluey
blur66020533blur_
blurb95214903blurb
blurry11437673blurry
blurs74619083blurs
blurt77625623blurt
bourg84113843bourg
bourn75518483bourn
bousy104917843bousy
buoy95921783_buoy
bur55744693_bur_
bura66139533_bura
burb85334673_burb
burd75534263_burd
burg74930363_burg
burl64937183_burl
burly104922833_burly
burn65636423_burn
burp85028883_burp
burr65631233_burr
burry105221563burry
burs65847423_burs
bursary12397583bursary
busboy13307443busboy
busby126113293bus_by
bushy135416683bus_hy
busily112211503busily
busty105621013bus_ty
busy94727173_busy
buy86436543_bu_y
carry105823783carry
cesura838763cesura
chary135023133chary
churl105913883churl
churn105113103churn
churr104512853churr
clary105719613clary
cory96941513_cory
court75532763court
cowry135512483cowry
crura7312583crura
cry89726243__cry
cur56841983_cur_
curb86732223_curb
curd77634983_curd
curdy115916523_curdy
cure66149123_cure
curf97538783_curf
curl66035053_curl
curly105321233_curly
curn66731883_curn
curr65429653_curr
curry105920343curry
curs65645543_curs
cursory12406393cursory
curt67051713_curt
curvy136013373_curvy
cushy134412323cus_hy
dairy97016303dairy
daubry12445483daubry
dauby115211223dauby
deary95826843deary
decry115514353decry
decury1277963decury
derry94721373derry
descry1256183descry
diary95016973diary
dory85836233_dory
dour56330433dour_
doura66518663doura
dourly103210433dourly
dowry126312483dowry
dry76526033__dry
duly85323033_duly
dupery12378743dupery
dura55232113_dura
dure56341813_dure
durn56127623_durn
duro56228023_duro
durr55624353_durr
dusky135213043dus_ky
dusty96018323dus_ty
duty85321453_duty
eery76129623_eery
elusory1083993elusory
emery104814333emery
ensure63416003ensure
entry82414263entry
enure53520223enure
espy969373es_py
essay867623essay
estray95713333estray
estuary1034683estuary
euro45325273_euro
every115215453every
exurb1457703exurb
eyry106315883_eyry
faery116015483faery
fairy115318283fairy
ferry116020803ferry
fiery114714793fiery
firry115713533firry
fleury12417353fleury
floury12449573floury
fluky154512293fluky
flurry12397113flurry
fluty114415643fluty
four76226863four_
fours85521493fours
fry96226503__fry
fumy127118583_fumy
fur66637323_fur_
furl77030883_furl
furry116719283furry
furs76735043_furs
furzy2010116063_furzy
fussy115613953fus_sy
fusty115016513fus_ty
fusuma1134503fusuma
future939563future
gaudy106611463gaudy
gaur56723353gaur_
gaurs66317993gaurs
gauzy18489213gauzy
glary96018543glary
glory96413293glory
gluey95715263gluey
gory86129663_gory
gourd71011903gourd
gouty95217363gouty
gurry94515413gurry
guru54623913_guru
gushy125213123gus_hy
gussy95314323gus_sy
gusty95119573gus_ty
guy75728943_gu_y
hairy115316833hairy
harry115322953harry
henry114014473henry
herry114922473herry
hoary114516763hoary
hour75827313hour_
houri85915233houri
hourly12369623hourly
hours85422383hours
hungry1334973hungry
hurl76029933_hurl
hurly115819293_hurly
hurry114917183hurry
hurt77142573_hurt
husky156112563hus_ky
hussy116812763hus_sy
injury16266143injury
insure63416603insure
inure54119053inure
inurn53712863inurn
ivory1137373ivory
jerry155016183jerry
jura116024893_jura
justly16307253justly
kauri93811843kauri
kerry124916093kerry
knur85311973knur_
knurl9398913knurl
knurly13405533knurly
knurs94511153knurs
kuru85521803_kuru
laura54116203laura
leary85927383leary
leery85919133leery
lorry86315663lorry
lory75931713_lory
lour45430683lour_
lours55125293lours
lousy84617083lousy
luny77324133_luny
lure45142463_lure
lurk86624163_lurk
lushly12247343lushly
lustra6358893lustra
lustre64011683lustre
lusty85417573lus_ty
lusus54813873lusu_s
marry104821693marry
merry104721483merry
miry96326743_miry
misery114113543misery
moory105115793moory
mourn77215013mourn
mousy106716943mousy
mura65633293_mura
mure65941333_mure
murk105527253_murk
murky145216683_murky
murr65225133_murr
murry105120233murry
muscly1337453muscly
muser76024123muser_
musers84719093musers
mushy135316633mus_hy
musky144715293mus_ky
mussy104117643mus_sy
musty105620953mus_ty
nary76931223_nary
nurd56224343_nurd
nurl45327243_nurl
nursery10396023nursery
ochry13346933ochry
onery8414113onery
osar46820953osar_
osprey1134883osprey
ossuary1043943ossuary
our36042893_our_
ours47237563_ours
outcry1137993outcry
ovary1149113ovary
parry105323753parry
pastry114913033pastry
peery105719443peery
penury1148103penury
perry105222713perry
plumy124213233plumy
pour611527473pour_
pours74623183pours
pouty107018813pouty
pry85728053__pry
puggry13374823puggry
puny95526993_puny
pur56840553_pur_
pure65543333_pure
puri65931443_puri
purl65631423_purl
purr64925813_purr
purs65641043_purs
pursy105016413_pursy
purty105019403_purty
pushy134614353pus_hy
pusley11379613pusley
pussly11407373pussly
pussy105614843pus_sy
quarry1837463quarry
quay164618353_quay
query174212083query
quey164616473_quey
rasure6311423rasure
rebury11349213rebury
redry94314363redry
refry114412463refry
retry84718083retry
rosary92810353rosary
rosery93813283rosery
roupy106112713roupy
ruby97819943_ruby
rudery10419033rudery
ruly76323143_ruly
rushy115414813rus_hy
rusty85221053rus_ty
sagy85327083_sagy
sard55344243_sard
sari45444043_sari
sark84938973_sark
sarky125521783_sarky
saucy104615163saucy
say67264763_s_ay
scary105222593scary
scurf104719323scurf
scurfy14338763scurfy
scurry11419583scurry
scurvy14386103scurvy
ser36752403_ser_
sera46141393_sera
sere46153473_sere
serf76340113_serf
serry84824123serry
sers45746653_sers
sexy146418023_sexy
shay107133343_shay
shri76021693_shri
shy96728193_s_hy
sir35746673_sir_
sire46150413_sire
sirs44338333_sirs
sizy164816393_sizy
sky106420993_s_ky
slay76436383_slay
slur45525153slur_
slurb74116323slurb
slurp74014983slurp
slurry9378593slurry
slurs54123373slurs
sly66228563_s_ly
sora45746913_sora
sorb68333043_sorb
sord56237203_sord
sore47059533_sore
sori46039833_sori
sorn46641063_sorn
sorry84618253sorry
sort46264813_sort
soupy106115403soupy
sour45935893sour_
sourly93612203sourly
sours55230503sours
soy67851453_s_oy
spay96631663_spay
spiry105017353spiry
spray106720063_spray
spumy124610363spumy
spur65321193spur_
spurn74815453spurn
spurry11429113spurry
spurs74621523spurs
spurt77227983spurt
spy86023743_s_py
sri35634003_s_ri
stay78333723_stay
stey76224413_stey
story86723033story
stoury9529943stoury
stray88525573_stray
stroy87720393_stroy
study94411793study
sturdy1037043sturdy
sturt56028963sturt
sty66227313_s_ty
suasory1046043suasory
sub55445553_su_b
suba64926603_suba
subs66037123_subs
suburb1037163suburb
such96424813_such
suck106131733_suck
sucky144415503sucky
sucre75019103sucre
sudary1038703sudary
sudd64719773_sudd
suds56135293_suds
sudsy95010683sudsy
sue35651463_su_e
sued56537933_sued
suer45334033_suer
suers55128483suers
sues46247653_sues
suet46754823_suet
suety85318493suety
sugary1039013sugary
sugh86423443_sugh
suit45649873_suit
suk75632973_su_k
suks85927123_suks
sulfury1345163sulfury
sulk85326653_sulk
sulky124715363sulky
sully84622893sully
sultry938463sultry
sulu45128423_sulu
sum56346013_su_m
sumo67326313_sumo
sump86331533_sump
sums65837583_sums
sun37149033_su_n
sundry1057943sundry
sung55832173_sung
sunk85031813_sunk
sunn45423593_sunn
sunny84917743sunny
sunray9310123sunray
suns45841903_suns
sup57041943_su_p
supe65932763_supe
supra73614253supra
sups64834433_sups
suq126228993_su_q
suqs134319653_suqs
surah86823253_surah
sural55931263_sural
suras55336323_suras
surds65624663_surds
surely93816453_surely
surer54833093_surer
surety93515003_surety
surfs85022543_surfs
surge65027693_surge
surra55521343surra
surrey94414573surrey
survey124111663_survey
suss45229303_suss
sutra54217933sutra
suture6313203suture
sway107128233_sway
tarry85422513tarry
teary85124053teary
terry84721873terry
thurl84912683thurl
tory75840543_tory
tour45530373tour_
tours55325863tours
truly84111553truly
try66529673__try
tsar47819803tsar_
tsars56717103tsars
tsuba745563tsuba
tsuris62710203tsuris
turd56027623_turd
turf75334053_turf
turfy114315403_turfy
turk86125863_turk
turn46330383_turn
tushery1335633tushery
tushy114212993tus_hy
tussur6357293tussur_
tussurs7356373tussurs
ugly86012383u_gly
ultra539363ultra
ulu36028703ulu__
ulus45622563ulu_s
umbra948503umbra
unarm7314453unarm
unbusy1135213unbusy
uncoy104111413uncoy
uncurb1037043uncurb
uncurl839413uncurl
unduly1037823unduly
undy85015163u_ndy
unfurl937953unfurl
unhurt9311253unhurt
unify113611113unify
unity84918493unity
unlay84613703unlay
unpure82911533unpure
unruly938083unruly
unsay83212843unsay
unsexy16296903unsexy
unsung736983unsung
unsunk1036333unsunk
unsurely1146383unsurely
unwary1239823unwary
upby1139063u_pby
upcurl1034963upcurl
upsurge10134333upsurge
upturn8286243upturn
urare56322553urare
urari54619963urari
urb55731103__urb
urd46427043__urd
urn35731463__urn
urp56426393__urp
urus46426133uru_s
us26937433us___
usably11288983usably
usage6410213usage
use36835163us__e
used55722823us_ed
uses44931113us_es
usher84517763usher
ushers94415533ushers
using66317963using
usnea539393usnea
usque14137733usque
usques15126803usques
usually1066063usually
usuals637783usuals
usurers766363usurers
usuries7510633usuries
usurped1035153usurped
usurper934353usurper
uteri51012983uteri
uvula845153uvula
vary105226063_vary
veery115816253veery
very108025643_very
vestry1238623vestry
wary106740013_wary
wastry12388773wastry
waur76819903waur_
weary115620613weary
wiry106422833_wiry
worry116114333worry
wry96524703__wry
wussy115810343wus_sy
yeuky15547033yeuky
your78623433your_
yourn87512773yourn
yours85217873yours
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.1101624463.6
2DLD Change Limit836675324.40618989.3
3Display Results5325320.1533477.1
 (SQL Overall)1786915324.66938271.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.