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

187 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
acted8852173(None) 
aced79540881ac_ed
ached119227831ached
acned87520661acned
acred87126351acred
anted66328241anted
aahed917816442aahed
abated95918452abated
abed79734132a_bed
abled86926832abled
accede1138292accede
ace59656832ac_e_
aces67645092ac_es
aceta74017352aceta
ache96829822ache_
aches106132292aches
acid77533392ac_id
ackee115825362ackee
acme86924322acme_
acmes96020652acmes
acne66625872acne_
acnes75922622acnes
acold86214922acold
acre67330772acre_
acres76327762acres
acrid86920102acrid
act59557842act__
acta69524802act_a
actin74922552actin
actor71116072actor
acts66929862act_s
acute74720362acute_
acuter84412862acuter
acutes83917722acutes
added84918432added
adzed166012542adzed
after85719792after
aged67334252a_ged
ahed89536252a_hed
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
airted74214502airted
alated75625142alated
alter54828502alter
amped104820512amped
ante46538902ante_
anteed75616112anteed
antes56334322antes
aped78538152a_ped
apter76120202apter
arced88224162arced
arched125717322arched
arcked136211942arcked
armed86324432armed
artel56122742artel
ashed97829772ashed
asked106919312asked
aster55434892aster
ate37059242a_te_
ates45047922a_tes
attend7258972attend
autoed7712822autoed
awed88436032a_wed
awned96615952awned
axed128829612a_xed
axled135315812axled
azoted16388592azoted
bached145519892bached
backed155725722backed
baited95319242baited
basted95227232basted
bated85935532bated
batted95623652batted
bracted12410932bracted
cached145419202cached
caged95426362caged
caked126128622caked
caned85838092caned
canted94825782canted
caped104931802caped
cared86050092cared
carted98631442carted
cased86032412cased
cate66254592cate_
cater74840702cater
cates75951872cates
catted95422472catted
caved116227562caved
cawed116627062cawed
cited84421952cited
coacted123611602coacted
coed77140542_coed
coted85033852coted
cred76530882_cred
cued76329562_cued
darted84620922darted
dated75530992dated
dauted84114932dauted
dawted11489682dawted
doted75227072doted
ducted104012122ducted
eched116919222eched
enacted10310642enacted
exacted1737302exacted
faced117727652fac_ed
faceted13509562faceted
farted105121782farted
fasted105320952fasted
fated95632132fated
fatted105419842fatted
feted94420932feted
fracted1339372fracted
gaited84416922gaited
gasted84821582gasted
gated75329772gated
hacked164923512hacked
hafted134713832hafted
halted105019602halted
hanted104124312hanted
hasted105125282hasted
hated95734022hated
hatted104921512hatted
iced78721892ic_ed
jacked204817522jacked
kited105120092kited
laced87132642lac_ed
lacked135324652lacked
lasted74323602lasted
lated65240672lated
luted64826142luted
maced108528692mac_ed
macled116718112macled
malted94819852malted
marted94425212marted
masted94025802masted
mated85537782mated
matted94521412matted
meted85424432meted
muted85023382muted
nacred95212492nacred
noted65123842noted
octad81510652octad
octet7324062octet
opted84914272opted
outed65429062outed
paced106931682pac_ed
packed154822602packed
panted95024822panted
parted94228682parted
pasted94426902pasted
pated85237842pated
patted94724682patted
raced87635312rac_ed
racked134526082racked
rafted104714702rafted
ranted74324702ranted
rated65441382rated
ratted74923342ratted
reacted103015712reacted
sacked135525212sacked
sacred94917102sacred
salted74121202salted
sated66238532sated
sauted74119602sauted
sited65130742sited
tacked134723942tacked
tarted74923372tarted
tasted74123972tasted
tatted74920532tatted
tauted75317112tauted
ted46446562__ted
toted64929482toted
unacted10312732unacted
vacated1349352vacated
vatted104214732vatted
voted93919142voted
wafted134012142wafted
waited103819772waited
wanted104319722wanted
warted104223232warted
wasted104423022wasted
wited94727142wited
wyted12529472wyted
yachted1634852yachted
yacked164516792yacked

Search took 7 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 Filter178691538000.360496363.9
2DLD Change Limit538001875.5309728.8
3Display Results1871870.1561198.7
 (SQL Overall)1786911876.04629555.2
 
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.