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

305 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
crus6582848(None) 
cris66233431cris
cru57129561cru_
crud75219611crud
cruds85815851cruds
cruse75726101cruse
crush106815991crush
crust75827661crust
crux135415001crux
curs65645541curs
ecrus75113861ecrus
urus46426131urus
acarus8312192acarus
acres76327762acres
amus65529612amus
anus47131112anus
arbs66834732arbs
arcs67834782arcs
arcus76918862arcus
ares45871022ares
arfs76029962arfs
argus66716542argus
arks85936872arks
arms66137492arms
ars37670932ar_s
arts49650262arts
arum66129032arum
arums75517832arums
bras65746452bras
bris65539612bris
bros65635662bros
brush105917472brush
brusk114912432brusk
brut66537962brut
bruts75922952bruts
brux136315272brux
burs65847422burs
bus56950972_bus
cabs86739422cabs
cads76144522cads
cams87047282cams
cans65050852cans
caps87147892caps
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carns75937562carns
carps96932252carps
carpus105514302carpus
carrs75730852carrs
cars67364762cars
carts78946292carts
casus76419252casus
cats66356342cats
caul65630002caul
cauls75727772cauls
cause75225352cause
caws96036102caws
cays95437672cays
cees65941592cees
cels65534972cels
ceps86125952ceps
cercus105013152cercus
ceres75540012ceres
cereus85215522cereus
ceros74726072ceros
cerous85821202cerous
ceruse83914522ceruse
cess65326052cess
chirus114615692chirus
chis95933312chis
chorus115014772chorus
chub115516412chub
chubs125412622chubs
chug105914112chug
chugs115511942chugs
chum116318002chum
chums125015832chums
cigs75625102cigs
circus104310592circus
cires74932912cires
cirrus8349172cirrus
cis57748032c_is
citrus83610922citrus
club85819472club
clubs95415102clubs
clue65324532clue
clues74623032clues
cobs87043142cobs
cods76848102cods
cogs77340032cogs
cols66553082cols
cons66057692cons
conus76726532conus
coos67456492coos
cops86751372cops
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
cornus84816562cornus
corps95927042corps
corpus106015292corpus
cors66656442cors
cos510270392c_os
coss66143492coss
cots68054842cots
coup86729792coup
coups95522472coups
cows97046642cows
coys97537242coys
crab85727672crab
crabs95421392crabs
crag75625302crag
crags85622572crags
cram85635492cram
crams96229152crams
crap85731842crap
craps95328642craps
crash109120012crash
crass76328042crass
craw97725262craw
craws105723122craws
cred76530882cred
creds85418772creds
cress75022832cress
crest74632692crest
crew96122672crew
crews105917492crews
crib86323582crib
cribs94516752cribs
cries75438402cries
crisp95014622crisp
crit65743712crit
crits75527572crits
croc85723732croc
crocs95722432crocs
crocus104813172crocus
crop87628632crop
crops96125232crops
cross75124502cross
croup95616782croup
croups104312552croups
crouse84619362crouse
crow96428132crow
crows105727312crows
cruces105117542cruces
cruck135615322cruck
crucks144412582crucks
crude86018572crude
crudes96218622crudes
cruel74815902cruel
cruet74831842cruet
cruets85314952cruets
cruise84314042cruise
crumb114313592crumb
crumbs12409232crumbs
crump115616422crump
crumps124514342crumps
cruor7310442cruor
cruors838632cruors
crura7312582crura
cruses88127712cruses
cruset84425092cruset
crusts84916542crusts
crusty114911342crusty
cruxes154911562cruxes
cry89726242cr_y
cub76940942c_ub
cubs85832382cubs
cud67937452c_ud
cuds76730472cuds
cue57544182c_ue
cues65438982cues
cum76440162c_um
cup76738242c_up
cups85430822cups
cur56841982c_ur
curb86732222curb
curbs94821652curbs
curd77634982curd
curds85725612curds
cure66149122cure
cures75645432cures
curf97538782curf
curfs105122142curfs
curl66035052curl
curls74927102curls
curn66731882curn
curns74924272curns
curr65429652curr
currs75624392currs
curse75829142curse
curst74931022curst
curt67051712curt
cusk105521632c_usk
cusp86021062c_usp
cuss65430612cuss
cut57957662c_ut
cuts65841152cuts
cwms11439572cwms
cyprus1335362cyprus
drub75920132drub
drubs85913832drubs
drug65718132drug
drugs75214652drugs
drum76521592drum
drums85415872drums
druse64817662druse
drys86314802drys
ecru65819532ecru_
ecus65421462ecus
emus66821682emus
eras45441502eras
ergs55523812ergs
erns45428222erns
eros45238452eros
errs45622532errs
ers36046282er_s
feus75830752feus
flus75626542flus
frug86517102frug
frugs96114282frugs
furs76735042furs
gnus56518002gnus
grub77220082grub
grubs86312602grubs
grue55825712grue
grues65721962grues
grum75625082grum
gurus64318192gurus
gyrus95310802gyrus
ictus7249702ictus
ires45639282ires
iris45732552iris
irks86220132irks
jus106930222_jus
kris86423602kris
kurus98015632kurus
mus55946752_mus
nous46136982nous
nus37939392_nus
onus45826812onus
opus66420592opus
orbs66626252orbs
orcs67025432orcs
ores46056682ores
ors35750112or_s
orts46538332orts
ours47237562ours
plus66324832plus
praus74621752praus
pros65742782pros
purs65641042purs
pus55547842_pus
ras37575392_ras
res35565042_res
rhus75114052rhus
rub56342822_rub
rubs66133492_rubs
rue35549262_rue
rues46044482_rues
rug46039152_rug
rugs56033682_rugs
rum56644642_rum
rums64833472_rums
run36244982_run
runs46438072_runs
ruse45938932_ruse
rush76628182_rush
rusk85823312_rusk
rust45544912_rust
rut35560522_rut
ruts44541492_ruts
scrub94914202scrub
scrubs104210312scrubs
scrum95418192scrum
scrums104614252scrums
sorus54527582sorus
sous46947212sous
sris45434152sris
taus46342732taus
thus76721472thus
torus54329762torus
tres46542902tres
true46725852true
trues54925322trues
trug55720042trug
trugs65516802trugs
truss54916922truss
trust55426852trust
ulus45622562ulus
urbs65922052urbs
urds55922422urds
urns46323892urns
urps66920472urps
us26937432__us
varus85921182varus
vaus75928922vaus
virus85316842virus
xerus12313332xerus
yous76230652yous

Search took 1 second 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.0602978183.3
2DLD Change Limit298723050.78338150.7
3Display Results3053050.0634841.3
 (SQL Overall)1786913050.906197230.7
 
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.