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

235 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
coated9492703(None) 
boated94221971boated
coacted123611601coacted
coaled95022701coaled
coapted123911491coapted
coasted104015941coasted
coatee84327211coatee
coater84329551coater
coaxed165612511coaxed
costed95623111costed
coted85033851co_ted
crated94827771crated
doated84118181doated
moated94819001moated
abated95918452abated
alated75625142alated
bated85935532_bated
bloated104513432bloated
boasted104113742boasted
boatel84314092boatel
boater84622092boater
bolted94617802bolted
booted94822732booted
borated104116362borated
caged95426362c_aged
caked126128622c_aked
caned85838092c_aned
canted94825782canted
caped104931802c_aped
cared86050092c_ared
carted98631442carted
cased86032412c_ased
cate66254592c_ate_
cater74840702c_ater
cates75951872c_ates
catted95422472catted
caved116227562c_aved
cawed116627062c_awed
ceased94920782ceased
cerated103922472cerated
chafed154813912chafed
chanted134015952chanted
chared125423692chared
charted135116852charted
chased125019292chased
chatted133411892chatted
chawed155214602chawed
cheated134416342cheated
chuted124611842chuted
cisted95217522cisted
cited84421952c_ited
clawed125115072clawed
clayed125013042clayed
cleated103417842cleated
cloaked14368542cloaked
clotted104011822clotted
clouted104212162clouted
coached153313842coached
coaler84121702coaler
coaster94219032coaster
coat67558342coat__
coatees93816532coatees
coaters93525772coaters
coati75624632coat_i
coatis85122592coatis
coats75634992coat_s
coattend1134642coattend
coaxer153912782coaxer
coaxes154715632coaxes
cocked155022562cocked
codded114515302codded
coded95433182co_ded
coed77140542co__ed
cogged116416612cogged
coifed124113062coifed
coiled95123932coiled
coined94523602coined
coked124730692co_ked
coled85540752co_led
collated113615062collated
colter84625092colter
comate104124842comate_
comates114123632comates
combated1539822combated
combed135516542combed
comped135919872comped
compted143813522compted
comte96125472comte_
comtes106222812comtes
coned86040052co_ned
conked135019112conked
conned95119702conned
conte76633202conte_
contend103511892contend
contes84432912contes
cooed84534342co_oed
cooeed95917862cooeed
cooked135921362cooked
cooled95224582cooled
cooped114821602cooped
coopted123710762coopted
cooter85128612cooter
coped105036842co_ped
copied114618562copied
copped135221252copped
copter109822012copter
corded105923352corded
cored85044222co_red
corked135020782corked
corned95224522corned
cortex15311462cortex
coshed124217542coshed
cosied94819882cosied
coster84331292coster
cote66648732co_te_
cotes76347842co_tes
cotter84926672cotter
counted103815802counted
couped115019312couped
courted103514912courted
couter84930202couter
coved115027372co_ved
coveted133011522coveted
cowed115637842co_wed
cowled125218382cowled
coxed154322812co_xed
coyed114623802co_yed
cozied184112152cozied
crafted13419772crafted
craned96121652craned
craped116120522craped
crate76537402crate_
crater85026632crater
crates85736052crates
craved125417772craved
crazed184714452crazed
created104323442created
croaked143710532croaked
curated104717582curated
dated75530992_dated
doited85016632doited
donated93513862donated
doted75227072do_ted
dotted84717522dotted
elated74725822elated
fated95632132_fated
floated113312702floated
foaled104515962foaled
foamed126014402foamed
footed104418622footed
gated75329772_gated
gloated93511532gloated
goaded94913712goaded
goaled85014352goaled
goatee73219532goatee
goateed9307062goateed
grated84523922grated
hated95734022_hated
heated104525592heated
hoaxed17378872hoaxed
hooted104422652hooted
hosted105020342hosted
hotted104319932hotted
iodated9310022iodated
jolted143510632jolted
jotted143615172jotted
lated65240672_lated
loaded84616872loaded
loafed104011152loafed
loamed94414612loamed
loaned73816292loaned
loathed11419442loathed
lobated102610942lobated
located103114182located
lofted103811892lofted
looted74421112looted
lotted74222402lotted
louted74920692louted
mated85537782_mated
meated94222402meated
moaned94514172moaned
molted94217472molted
mooted94120372mooted
notated82713662notated
noted65123842no_ted
oared65030652_oared
oaten55222402_oaten
oater55433732_oater
opted84914272_opted
orated74221502orated
outed65429062_outed
pated85237842_pated
plated95225772plated
ported94223242ported
posted93722492posted
potted94624012potted
pouted94021392pouted
prated94924922prated
rated65441382_rated
recoated113416782recoated
roamed95215092roamed
roared75015392roared
roasted83912662roasted
rooted75424002rooted
rotated82715292rotated
rotted74524432rotted
routed75624332routed
sated66238532_sated
scooted103612272scooted
scouted104112032scouted
seated75131052seated
skated114414872skated
slated75028312slated
soaked114717592soaked
soaped95817972soaped
soared74324292soared
solated83618022solated
sooted73922582sooted
sorted74523712sorted
sotted74121392sotted
stated75427832stated
teated74924022teated
toasted84011922toasted
togated94410662togated
toited74016752toited
tooted74620122tooted
toted64929482to_ted
totted74319952totted
touted74419742touted
uncoated11314962uncoated
voted93919142vo_ted
woaded115211602woaded
wonted103213282wonted
wotted104115712wotted
zonated173310532zonated

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.1101624463.6
2DLD Change Limit825512352.90328436.4
3Display Results2352350.0802937.5
 (SQL Overall)1786912353.09357772.7
 
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.