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

245 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
coster8433129(None) 
caster85232571caster
coaster94219031coaster
coater84329551coater
colter84625091colter
cooter85128611cooter
copter109822011copter
cosher114819901cosher
cosier84423751cosier
costar85518611costar
costed95623111costed
costers94128301costers
cotter84926671cotter
couter84930201couter
foster94322221foster
poster84129171poster
roster64329081roster
zoster153715851zoster
aster55434892_aster
baster85333592baster
bister84922762bister
boaster94616432boaster
boater84622092boater
bolster93713422bolster
bolter83920752bolter
booster94314552booster
bosker123813652bosker
buster84726492buster
canter85230112canter
carter84932272carter
caste75932362caste_
casters94729892casters
castes85631862castes
castor84418532castor
cater74840702c_ater
center84421412center
chaster124718502chaster
cisted95217522cisted
cistern93310692cistern
citer74827322c_iter
cloister1037092cloister
closer84918202clos_er
clouter93511682clouter
cluster94013322cluster
clyster12317452clyster
coaler84121702coaler
coasted104015942coasted
coasters104317302coasters
coated94927032coated
coatee84327212coatee
coaters93525772coaters
coaxer153912782coaxer
cobber124116842cobber
cocker144320392cocker
codder104416332codder
coder86134212co_der
codger105814842codger
coffer144112862coffer
coiler84421592coiler
coiner84323782coiner
cointer93616722cointer
colder95121832colder
colters93522432colters
comber125118502comber
comer95832692co_mer
comte96125472comte_
comtes106222812comtes
confer114018682confer
conger95024272conger
conker124721552conker
conner84423962conner
conte76633202conte_
contes84432912contes
cooer74831012co_oer
cooker124722452cooker
cooler84824712cooler
cooper104221122cooper
cooters94525712cooters
coper95336092co_per
copier103722892copier
copper124321892copper
copters113621272copters
corder94322872corder
corer75538872co_rer
corker124720852corker
corner84625622corner
cortex15311462cortex
cosec96320182cos_ec
coses76949492cos_es
coset75748842cos_et
cosets85824402cosets
cosey106226712cos_ey
coshed124217542coshed
coshers123618172coshers
coshes115022782coshes
cosie74728262cosie_
cosied94819882cosied
cosies84932152cosies
cosset84125862cosset
cost68057942cost__
costa75523732cost_a
costae85319682costae
costal85419512costal
costard104113352costard
costars94217992costars
costlier1038522costlier
costly114012332costly
costrel9310362costrel
costs77231142cost_s
costumer1275102costumer
cote66648732co_te_
coted85033852co_ted
cotes76347842co_tes
cottar84613812cottar
cotters94323432cotters
cottier93814172cottier
coulter94115592coulter
counter94220142counter
courter94516462courter
couters93827282couters
couther123914622couther
cover105430772co_ver
coveter122912062coveter
cower104531772co_wer
cowier113616162cowier
coyer105222842co_yer
cozier173315142cozier
crater85026632crater
crofter12299572crofter
crosier94116572crosier
crosser95015462crosser
curter85320072curter
cusser86016092cusser
cuter74728222c_uter
cutter84520992cutter
doser66228562dos_er
dosser74417972dosser
doter65428622do_ter
dotter74419342dotter
duster74919722duster
easter65027982easter
ester54727712_ester
faster94625772faster
fester94723512fester
footer94320762footer
fosters104220092fosters
gaster75027352gaster
goiter74116202goiter
hoister103714202hoister
holster103512212holster
hooter94123922hooter
hoser811529762hos_er
hosier94219612hosier
hosted105020342hosted
hostel93914152hostel
hostler103411022hostler
hotter94720072hotter
jester134319152jester
jolter133513092jolter
josher164312962josher
jostler14288222jostler
jotter134315632jotter
jouster143311042jouster
juster134617012juster
kosher134412972kosher
laster64830632laster
lister64527252lister
lobster9288852lobster
lofter94614722lofter
loiter64619172loiter
looter64222322looter
loser54728672los_er
lotter64025602lotter
luster64023672luster
master84831342master
mister84728562mister
mobster11299212mobster
moister94015372moister
molter84119422molter
monster93214592monster
mooter83921092mooter
mosher114719792mosher
mosser84618272mosser
moste75925082moste_
muster84724522muster
nester64124182nester
nosher94616362nosher
nosier63716322nosier
noter55025642no_ter
oater55433732_oater
ofter84116872_ofter
osier53518012_osier
ostler63312192_ostler
otter54423972_otter
ouster64223732ouster
outer55633302_outer
oxter123414092_oxter
oyster94111702oyster
paster85734372paster
pester84827592pester
porter84224412porter
poser75128772pos_er
posher115018162posher
posted93722492posted
postern93615602postern
posters93927992posters
potter83926982potter
pouter83923982pouter
powter114116032powter
raster64731442raster
rester63832432rester
roaster74116662roaster
roister73516202roister
rooster74415172rooster
rooter64926032rooter
rosier64221262rosier
rosters73727532rosters
rotter64325462rotter
rouster73517082rouster
router65025842router
royster103110532royster
scooter93312862scooter
scoter83815472sco_ter
scouter93313322scouter
sister64421582sister
softer94015312softer
sorter64425082sorter
souter64225922souter
taster64930572taster
tester64227152tester
toaster74414462toaster
tooter64420802tooter
tosser64215662tosser
toter55932132to_ter
totter65021462totter
touter63821032touter
ulster63712102ulster
vaster94521022vaster
voter85121052vo_ter
waster95228942waster
wester94222892wester
xyster16366802xyster
yester93417982yester
zester153617792zester
zosters163015402zosters

Search took 4 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 Filter178691825510.1261418182.5
2DLD Change Limit825512453.22025637.0
3Display Results2452450.0763223.7
 (SQL Overall)1786912453.42252218.3
 
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.