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

165 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
patriot931453(None) 
patriots1038051patriots
parrot8320662pa_rrot
patio74426352pat_io_
patios85221782pat_ios
patriate10311932patriate
patriotic13107582patriotic
patrol83213022patr_ol
patron84018042patr_on
patroon92811972patroon
postriot10412252postriot
preriot9316412preriot
adrift10313113_adrift
adroit7518793_adroit
afrit8323173_afri_t
antiriot8414583antiriot
aorist64827873_aorist
apricot111010183_apricot
argot67728653_a_rgot
artist64125543_artist
astrict9614793astrict
atilt54828473_at_ilt
atria56022343_atri_a
atrial65418943_atrial
atrip75315753_atri_p
atrium8411823_atrium
attrit6315753attri_t
aurist65027253_aurist
barrio8312573barrio_
barrios9310773barrios
carrion9312673carrion
carrot8423123ca_rrot
cation83925503cat_ion
catmint11314463catmint
chariot12316213chariot
compatriot1655963compatriot
estriol747553estriol
galiot72322593ga_liot
galliot82214133galliot
griot65328413__griot
haricot12311963ha_ricot
harlot94422803ha_rlot
heriot9422343_heriot
iatric8312163iatri_c
introit7414533introit
kation104315683kat_ion
lariat6629043la_riat
latria62313593latri_a
latrias71913213latrias
latrine7715123latrine
marmot10318743ma_rmot
matelot9411573matelot
matrix1539843matri_x
matron83918313matr_on
matzot17710983mat_zot
metrist9317063metrist
nation64322803nat_ion
natrium948983natrium
natron64116023natr_on
naturist8410813naturist
outroot7516563outroot
paction112713963paction
padri85815173padri__
paint75443693pa__int
pairing103716733pairing
paletot9413713paletot
palmist112814343palmist
paltrier1037523paltrier
paltriest1138603paltriest
paltrily1345413paltrily
pandit93820753pandi_t
pantries101817393pantries
papist102618743pa_pist
paprica1337003paprica
paprika1544003paprika
pardon94618733pa_rdon
parent83230423pa_rent
pareo74632603pa_reo_
pareos87023773pa_reos
parget94529393pa_rget
pargo86723723pa_rgo_
pargos95719043pa_rgos
pariah114320583pa_riah
parian83223963pa_rian
paries84742513pa_ries
paring94236493pa_ring
paris75145943pa_ri_s
parish115022353pa_rish
parity114719873pa_rity
parlor8312673pa_rlor
parol74826273pa_r_ol
parried103615723parried
parrier93717653parrier
parries93925843parries
parring103222063parring
parrots9312743pa_rrots
parroty1247863pa_rroty
parson83817903pa_rson
part65967463pa_r__t
partial92616263partial
partied103516553partied
partier93520713partier
parties93230863parties
parting103527383parting
partita9310863partita
partite9317133partite
partlet92720363partlet
parton84720993pa_rton
partook1337313partook
parvo107719183pa_rvo_
parvos116614753pa_rvos
passion9310883passion
pastries101517423pastries
patent84524923pat_ent
pathos115516693pat_hos
patient9617073patient
patin76832853pat_i_n
patina86022193pat_ina
patine85328123pat_ine
patins87528783pat_ins
patois84319363patoi_s
patriated1238533patriated
patriates11311363patriates
patrimony1642673patrimony
patriotism1454203patriotism
patristic1389283patristic
patrols93513513patrols
patrons93818103patrons
patroons102710603patroons
patsies93919483patsies
pattie84020963patti_e
patties93425143patties
patting103722343patting
pavior1138533pa_vior
peridot10514243p_eridot
period9314983p_eriod
petit74332653pet_i_t
petrify1536573petrify
petrol82714063petr_ol
pierrot948833pierrot
portion9615493portion
potion84519573pot_ion
potshot1249733potshot
print74837463p__rint
prion75119993p__rion
prior74316173p__rior
purist85525053p_urist
putrid9311173putri_d
ratio55227583rat_io_
ration64226013rat_ion
ratios64922673rat_ios
riot45947213___riot
sacrist9315423sacrist
satirist8313503satirist
strict84821043_strict
stript85222193_stript
taproot9412673taproot
tarot55943933ta_r_ot
tricot8317753__tricot
trio45233343__trio_
triol55521363__triol
trios55528093__trios
trot46351313__tr_ot
vitriol1045693vitriol
warrior1045363warrior

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271656.03022226.7
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.49927495.2
 
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.