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

268 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
parted9422868(None) 
carted98631441carted
darted84620921darted
farted105121781farted
marted94425211marted
panted95024821panted
pared86946761par_ed
parged104922041parged
parked134425141parked
parled94626291parled
parred95024071parred
parsed96323891parsed
partied103516551partied
pasted94426901pasted
pated85237841pa_ted
patted94724681patted
ported94223241ported
prated94924921prated
tarted74923371tarted
warted104223231warted
acted88521732_acted
airted74214502airted
anted66328242_anted
arced88224162_arced
armed86324432_armed
artel56122742_artel
baited95319242baited
barbed115121312barbed
barded105426422barded
bared85144482bar_ed
barfed125416382barfed
barged105822642barged
barked135027312barked
barned95623582barned
barred95725792barred
bartend1038752bartend
barter85525372barter
basted95227232basted
bated85935532ba_ted
batted95623652batted
biparted1335132biparted
canted94825782canted
carded105424902carded
cared86050092car_ed
caried94528692caried
carked134024822carked
carped115923762carped
carte75940422carte_
cartel85022532cartel
carter84932272carter
cartes86239472cartes
carved124320852carved
catted95422472catted
charted135116852charted
crated94827772crated
dared75935012dar_ed
darked123919632darked
darned85018482darned
darter75320362darter
dartled9409852dartled
dated75530992da_ted
dauted84114932dauted
dawted11489682dawted
departed1238822departed
eared65139502ear_ed
earned74818332earned
earthed1139922earthed
farced125216532farced
farded114518952farded
fared95842342far_ed
farmed125117652farmed
fasted105320952fasted
fated95632132fa_ted
fatted105419842fatted
gaited84416922gaited
garbed104815662garbed
garoted9710132garoted
garred85217412garred
garter74420512garter
gasted84821582gasted
gated75329772ga_ted
girted83912872girted
grated84523922grated
hafted134713832hafted
halted105019602halted
hanted104124312hanted
hared95742182har_ed
harked145422552harked
harmed125218832harmed
harped124418402harped
hasted105125282hasted
hated95734022ha_ted
hatred104814332hatred
hatted104921512hatted
hearted113314022hearted
imparted13248062imparted
jarred144613252jarred
larded84319092larded
larked114519472larked
lasted74323602lasted
lated65240672la_ted
malted94819862malted
marked133921622marked
marled95523162marled
marred95421042marred
marten84518262marten
masted94025802masted
mated85537782ma_ted
matted94521412matted
narked114116742narked
oared65030652oar_ed
orated74221502orated
paced106931682pa_ced
packed154822602packed
padded114113502padded
paged95926782pa_ged
paiked135113432paiked
pained95622852pained
painted104214632painted
paired95017522paired
paled85538722pa_led
palled94625162palled
palmed114314642palmed
palped114513642palped
palter84423262palter
paned85437182pa_ned
panged104722332panged
panned94123432panned
parade94720642parade
paraded114014262paraded
parae76335702parae_
parcel103915472parcel
parched154013692parched
pard76441322par__d
pardee93922022pardee
pare66760842par_e_
parented11912212parented
pareo74632602par_eo
parer75839902par_er
pares77164482par_es
pareu74928742par_eu
parge85831852parge_
parges94529542parges
parget94529392parget
pargeted1238682pargeted
paries84742512paries
parker124121372parker
parle75836162parle_
parles86334402parles
parley116718362parley
paroled104217632paroled
parotid102915512parotid
parrel84515982parrel
parried103615722parried
parroted1158842parroted
parse75236992parse_
parsec105914482parsec
parser84822372parser
parses85534702parses
part65967462part__
partan83820562partan
partier93520712partier
parties93230862parties
partlet92720362partlet
partly116315472partly
partner92811392partner
parton84720992parton
parts77743372part_s
party106630612part_y
partyer12337872partyer
parve109824852parve_
pashed125923142pashed
passed94320942passed
paste74932952paste_
pastel85918712pastel
paster85734372paster
pastes85233912pastes
pate65350462pa_te_
paten74827342pa_ten
pater74740722pa_ter
pates76047892pa_tes
pattee84323382pattee
patten84418192patten
patter84628262patter
paused95114962paused
paved115525262pa_ved
paveed12438892paveed
pawed115725612pa_wed
pawned124513282pawned
payed115925932pa_yed
pearled10411552pearled
pearter9412742pearter
pelted94617762pelted
perked134617692perked
permed115217352permed
perter84422282perter
petted94121522petted
pirated102515612pirated
pitted94319592pitted
plaited103713892plaited
planted103516122planted
plated95225772plated
platted103614262platted
pored85234512por_ed
porked134717622porked
portend103411192portend
porter84224412porter
posted93722492posted
potted94624012potted
pouted94021392pouted
prate75135982prate_
prater84825352prater
prates84633162prates
prayed124815432prayed
preed85128122p_reed
pried84426862p_ried
punted94618712punted
pureed95017812pureed
purged104918262purged
purled94520752purled
purred94218072purred
pursed95220882pursed
putted94220252putted
rafted104714702rafted
ranted74324702ranted
rared65738322rar_ed
rated65441382ra_ted
ratted74923342ratted
salted74121202salted
sated66238532sa_ted
sauted74119602sauted
scarted104816122scarted
smarted105012612smarted
sorted74523712sorted
spared95427492spar_ed
sparged113512762sparged
sparked143513142sparked
sparred104512862sparred
spatted104014142spatted
spirted103913072spirted
sported104015432sported
spurted103111972spurted
started84217322started
tared69340052tar_ed
tarred74720282tarred
tarter64023562tarter
tasted74123972tasted
tatted74920532tatted
tauted75317112tauted
unparted11310822unparted
updarted1244312updarted
uprated103213322uprated
varied104817862varied
varved134110602varved
vatted104214732vatted
wafted134012142wafted
waited103819772waited
wanted104319722wanted
warded115021042warded
wared96339872war_ed
warked144421212warked
warmed124516892warmed
warned104018912warned
warped124816412warped
warred104019842warred
wasted104423022wasted
yarded114714022yarded
yarned105514022yarned

Search took 3 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.343520965.0
2DLD Change Limit825512682.42034112.0
3Display Results2682680.0803350.0
 (SQL Overall)1786912682.84362853.0
 
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.