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 “urus” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

234 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
urus4642613(None) 
crus65828481crus
gurus64318191gurus
kurus98015631kurus
ulus45622561ulus
urbs65922051urbs
urds55922421urds
urns46323891urns
urps66920471urps
amus65529612amus
anus47131112anus
arbs66834732arbs
arcs67834782arcs
arcus76918862arcus
ares45871022ares
arfs76029962arfs
argus66716542argus
arks85936872arks
arms66137492arms
ars37670932ar_s
arts49650262arts
arum66129032arum
arums75517832arums
auras55932552auras
aures55137092aures
aureus65314882aureus
auris55331522auris
aurous64119262aurous
aurum7614962aurum
aurums849382aurums
bras65746452bras
bris65539612bris
bros65635662bros
brush105917472brush
brusk114912432brusk
brut66537962brut
bruts75922952bruts
brux136315272brux
bubus95115452bubus
buras74736292buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burls74228852burls
burns74926772burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
bus56950972_bus
cris66233432cris
cru57129562cru_
crud75219612crud
cruds85815852cruds
cruse75726102cruse
crush106815992crush
crust75827662crust
crux135415002crux
curbs94821652curbs
curds85725612curds
cures75645432cures
curfs105122142curfs
curls74927102curls
curns74924272curns
currs75624392currs
curs65645542cur_s
drub75920132drub
drubs85913832drubs
drug65718132drug
drugs75214652drugs
drum76521592drum
drums85415872drums
druse64817662druse
drys86314802drys
dufus94010812dufus
duras65727722duras
dures65635922dures
durns64819862durns
duros65422692duros
durrs65519992durrs
durum8513202durum
durums948152durums
ecrus75113862ecrus
ecus65421462ecus
emus66821682emus
eras45441502eras
ergs55523812ergs
erns45428222erns
eros45238452eros
errs45622532errs
ers36046282er_s
euros54920242euros
feus75830752feus
flus75626542flus
frug86517102frug
frugs96114282frugs
fucus105515892fucus
fugus95914012fugus
furls85322052furls
furs76735042fur_s
gnus56518002gnus
grub77220082grub
grubs86312602grubs
grue55825712grue
grues65721962grues
grum75625082grum
guru54623912guru_
gyrus95310802gyrus
humus106215072humus
hurds95219072hurds
hurls86522712hurls
hurts86922822hurts
ires45639282ires
iris45732552iris
irks86220132irks
jujus11347462jujus
jukus16398672jukus
jus106930222_jus
kris86423602kris
kudus104910802kudus
kuru85521802kuru_
luaus54514902luaus
lulus54315162lulus
lupus74512522lupus
lures56138532lures
lurks95218742lurks
lusus54813872lusus
mucus94015742mucus
mumus95517282mumus
muras75329562muras
mures75937212mures
murks114821722murks
murrs75521292murrs
mus55946752_mus
nous46136982nous
nurds65518522nurds
nurls55519682nurls
nus37939392_nus
onus45826812onus
opus66420592opus
orbs66626252orbs
orcs67025432orcs
ores46056682ores
ors35750112or_s
orts46538332orts
ours47237562our_s
plus66324832plus
praus74621752praus
pros65742782pros
pupus94614042pupus
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
pus55547842_pus
qurush1835502qurush
ras37575392_ras
res35565042_res
rhus75114052rhus
rub56342822_rub
rubs66133492rubs
rubus76415052rubus
rue35549262_rue
rues46044482rues
rug46039152_rug
rugs56033682rugs
rum56644642_rum
rums64833472rums
run36244982_run
runs46438072runs
ruse45938932_ruse
rush76628182_rush
rusk85823312_rusk
rust45544912_rust
rut35560522_rut
ruts44541492ruts
sorus54527582sorus
sous46947212sous
sris45434152sris
sulus54821882sulus
suras55336322suras
surds65624662surds
surfs85022542surfs
taus46342732taus
thus76721472thus
torus54329762torus
tres46542902tres
true46725852true
trues54925322trues
trug55720042trug
trugs65516802trugs
truss54916922truss
trust55426852trust
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623232turns
turps74918732turps
tutus55214812tutus
udos56619902udos
ughs85410972ughs
ukes86122812ukes
ulu36028702ulu_
umps85721942umps
unaus53216572unaus
uncus74014982uncus
uns35936752u_ns
upas68322382upas
uprush1135782uprush
ups55629052u_ps
uraeus638792uraeus
urase54624682urase
urb55731102ur_b
urd46427042ur_d
urea46528052urea
ureas55826012ureas
urge54722412urge
urges64619912urges
uric63624932uric
urn35731462ur_n
urp56426392ur_p
ursa44116902ursa
uruses63616502uruses
us26937432__us
uses44931112uses
utas45924952utas
uterus639192uterus
utes45930882utes
uts35534372u_ts
varus85921182varus
vaus75928922vaus
virus85316842virus
xerus12313332xerus
yous76230652yous
yurts87216532yurts

Search took 2 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 Filter178691298720.1231452772.4
2DLD Change Limit298722340.86034734.9
3Display Results2342340.0465087.0
 (SQL Overall)1786912341.029173655.0
 
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.