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 “partita” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

221 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
partita931086(None) 
partitas10310251partitas
partite9317131partite
pareira937532pareira
parity114719872par_ity
partial92616262partial
partied103516552partied
partier93520712partier
parties93230862parties
parting103527382parting
partisan1058422partisan
partizan1955642partizan
pastina93914592pastina
patina86022192pa_tina
spartina1037982spartina
agita6315423_a_gita
amrita8411133_amrita
antitax1447853_antitax
apatite9312963apatite
aria46245423_ar_i_a
arista6415293_arista
arnica8310443_arnica
arriba867683_arriba
artier63419733_artier
artily92814713_artily
artisan759463_artisan
artist64125543_artist
artiste73813693_artiste
artists74215593_artists
atria56022343_atri_a
barbital1247053barbital
barista9310813barista
barite84224813bar_ite
bartisan1056163bartisan
bartizan1954413bartizan
baryta114310293bar_yta
bipartite1344223bipartite
cantata93811813cantata
cantina93417253cantina
capita102913773ca_pita
cardia9916373cardi_a
carina84325323car_ina
caritas93316953car_itas
carting104228283carting
casita82913703ca_sita
cortina91915973cortina
darting94020663darting
fajita1635923fa_jita
farina94618233far_ina
farting114120753farting
gordita945093gordita
granita82111303granita
jarina134014063jar_ina
karting123716063karting
lariat6629043lar_iat
latina65621143la_tina
latria62313593latri_a
maranta9311693maranta
maria75032883mar_i_a
marina84623413mar_ina
marital92314183mar_ital
marlite92917073marlite
marmite112413993marmite
martial92415413martial
martian93514683martian
martin84122523marti_n
marting103325013marting
martini93613873martini
martins93322063martins
paction112713963paction
paisa76021073pa__isa
pallia83015593palli_a
pandit93820753pandit_
pandits103914213pandits
pantie84326473panti_e
panties94230933panties
pantile93918483pantile
panting104025423panting
paprica1337003paprica
paprika1544003paprika
para65242173par___a
parakite14410423parakite
parasite10314843parasite
pardi85723953pardi__
pardie96021443pardi_e
pardine103616723pardine
pareiras1038183pareiras
parent83230423parent_
parental10310943parental
parents93418123parents
parerga1035173parerga
paretic113016673pareti_c
paretics122312443paretics
parfait12312053parfait_
parfaits1346913parfaits
parget94529393parget_
pargets105215193pargets
parging113318603parging
pariah114320583par_iah
parian83223963par_ian
paries84742513par_ies
parietal1048773parietal
paring94236493par_ing
paris75145943par_i_s
parish115022353par_ish
parities10522973parities
parka115120883par__ka
parking143423043parking
parling103823763parling
parotic112518043paroti_c
parotid102915513paroti_d
parotids112610413parotids
parotitic1349323parotitic
parotitis1149173parotitis
parried103615723parried
parrier93717653parrier
parries93925843parries
parring103222063parring
parritch1543543parritch
parrot8320663parrot_
parrots9312743parrots
parroty1247863parroty
parsing103819553parsing
part65967463par__t_
partake1339643partake
partan83820563part_an
partans94418283partans
parted94228683part_ed
partials101911953partials
partible1238063partible
particle1239533particle
partiers103514243partiers
partings113513733partings
partisans1167483partisans
partition1148693partition
partitive1447373partitive
partizans2055243partizans
partlet92720363partlet
partlets102811513partlets
partly116315473part_ly
partner92811393partner
parton84720993part_on
partons94620513partons
partook1337313partook
parts77743373par__ts
partway1535923partway
party106630613par__ty
partyer12337873partyer
partying14168893partying
parura8310583par_ura
parvis116114803parvi_s
parvise124211693parvise
pasta76624533pa__sta
pastie85525523pasti_e
pastier94320383pastier
pasties94529813pasties
pastil85018323pasti_l
pastils94416173pastils
pastime114611973pastime
pastinas103712153pastinas
pasting103826553pasting
pastis84924323pasti_s
pastitso1043623pastitso
pataca10311193pa_taca
patin76832853pa_ti_n
patinae95414403pa_tinae
patinas96318523pa_tinas
patine85328123pa_tine
patins87528783pa_tins
patio74426353pa_ti_o
patios85221783pa_tios
patriate10311933patriate
patriot9314533patriot
patriots1038053patriots
pattie84020963patti_e
patties93425143patties
patting103722343patting
patty104723613pa_t_ty
paucity1435823paucity
pearlite1039443pearlite
pereia85217983perei_a
periti8319953per_iti
perlite9317313perlite
permit10321683permit_
permits11314003permits
petit74332653p_etit_
petite84320653p_etite
pita65436433p___ita
pitta75018693p_it_ta
platina94413643platina
poortith1355363poortith
portico11310143portico
porting103021783porting
portion9615493portion
prating103424453prating
prima95019343p_r_ima
pruta7314243p_r_uta
puritan939283pur_itan
purity114114913pur_ity
purtier93214093purtier
pyrite11913313pyr_ite
raita54623073__raita
rarity93615493rar_ity
ratite65022423ra_tite
sarcina9310733sarcina
sparsity1345463sparsity
spartinas1135793spartinas
tarsia65514273tarsi_a
tartana73010193tartana
tartier74123263tartier
tartily103511573tartily
tarting84222653tarting
tartish101512633tartish
varia85824203var_i_a
varsity1356673varsity
vastity1336203vastity
wartier103413913wartier
wartime1237743wartime
yautia937253yauti_a
zaratite1747793zaratite
zariba1736983zar_iba

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272216.98319193.3
3Display Results2212210.0802762.5
 (SQL Overall)1786912217.21924752.9
 
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.