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

211 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
patients108876(None) 
patents94815201pat_ents
patient9617071patient_
inpatients1244292inpatients
latents75214312lat_ents
paints85921832pa_i_nts
parents93418122pa_rents
patens84820862pat_en_s
patent84524922pat_ent_
patience1247522patience
patiences1367432patiences
patienter1145552patienter
patientest1245712patientest
patiently1445632patiently
patinas96318522pati_nas
patines95225762pati_nes
patins87528782pati_n_s
pattens95414922patten_s
payments1536942payments
salients839562salients
sapients1037422sapients
satinets8311732satinets
absents93510723_absents
accents113511233_accents
advents11309473_advents
agents74816293_a_gents
aliens65619213_alien_s
aliments10311093_aliments
ambients1246053ambients
aments85219803_a_ments
ancients1098973ancients
apartments1445703apartments
aperients1178253aperients
argents84014853_argents
arpents93613083_arpents
ascents93812553_ascents
assents74512223_assents
attends8257593_attends
attent62818323_attent_
attests7278813_attests
audients946353audients
basinets1039063basinets
battens95313263batten_s
cabinets1238283cabinets
catenas9313113cat_enas
cathects1545793cathects
cations94524143cation_s
catmints1236663catmints
clients938093_clients
detents83615153det_ents
eatings84616443eati_ngs
extents142610173ext_ents
faciends1443573faciends
faints94818783fa_i_nts
fattens105111713fatten_s
fitments1376793fitments
garments1139963garments
gatings95212823gati_ngs
gradients1145273gradients
haints94417583ha_i_nts
hutments1345603hutments
impatiens1345733impatien_s
impatient1347753impatient_
inpatient1147653inpatient_
intents72115703int_ents
kations114013663kation_s
laments94314853la_ments
lateens74210553lateen_s
latens64620213lat_en_s
latent64124303lat_ent_
latests73910313lat_ests
latinas74416463lati_nas
latinos73613803lati_nos
lattens75014673latten_s
margents11410133margents
martinets1138883martinets
matiest92522453matiest_
matinees102110423matinees
matiness102114753matiness
matings104516213mati_ngs
matins84527783mati_n_s
nations74720563nation_s
nutrients944423nutrients
orients7311583_orients
outpatients1351713outpatients
paciest112917813paciest_
packets155114773packe_ts
pactions122613503paction_s
pageants1136693pageants
pagings114411063pagi_ngs
pains75138283pa_i_n_s
paint75443693pa_i_nt_
painty114714753pa_i_nty
palets85122313pa_le_ts
paliest93021613paliest_
palings103915823pali_ngs
pallets93919303palle_ts
pandects1335843pandects
pangenes112612823pangenes
pangens103112063pangen_s
paniers94717333panie_rs
panties94230933pantie__s
pants76536923pa___nts
papists112110453papi_sts
paraments13511553paraments
parent83230423pa_rent_
pargets105215193parge_ts
parians93519733parian_s
paries84742513parie__s
parietes10714543parietes
parings104219213pari_ngs
partiers103514243partie_rs
parties93230863partie__s
partings113513733parti_ngs
partlets102811513partle_ts
parturients1352483parturients
parvenus1335653parvenus
pasties94529813pastie__s
pastiest103319553pastiest_
pastinas103712153pasti_nas
pastiness112312353pastiness
paten74827343pat_en__
patency1466313pat_ency
patented1188893pat_ented
patentee1099943pat_entee
patentees1196543pat_entees
patently1347113pat_ently
patentor1046373pat_entor
patentors1146743pat_entors
paters84935833pat_e_rs
pates76047893pat_e__s
patin76832853pati_n__
patina86022193pati_n_a
patinae95414403pati_nae
patinate103016313patinate
patinates113814693patinates
patine85328123pati_n_e
patined105114783pati_ned
patios85221783pati__os
patness92912283patne_ss
patriots1038053patriots
patrons93818103patron_s
patsies93919483patsie__s
patten84418193patten__
pattened11299393pattened
patterns10439943patterns
patters94825193patte_rs
patties93425143pattie__s
patulent1048603patulent_
patzers184210573patze_rs
pavements1647003pavements
pavings134011633pavi_ngs
pavins114919663pavi_n_s
payment14310703payment_
peatiest103118813peatiest_
pediments1448343pediments
pendents1139413pendents
penitents1147703penitents
percents122713373percents
perpents122312043perpents
pigments1337343pigments
pimiento1243253pimiento
pimientos1342833pimientos
pints75936223p__i_nts
pitiers93812653pitie_rs
pities83828083pitie__s
plaints94012053plai_nts
platens94213983plat_en_s
platies93722543platie__s
platiest103216093platiest_
platinas103610313plati_nas
platings113611363plati_ngs
points85618533p_oi_nts
portents103512823portents
poteens92910883poteen_s
potent84223353pot_ent_
potions93417423potion_s
precents123015043precents
presents103315643presents
prevents133012293prevents
priests93810863p_riests
prints84320103p_ri_nts
pschents1544113pschents
quotients1843023quotients
radiants9259443radiants
raiments1039903raiments
ratines75328583rati_nes
ratings84217413rati_ngs
rations74123433ration_s
rattens74213403ratten_s
retints74717013reti_nts
saints65122423sa_i_nts
salient7419763salient_
sapiens9310173sapien_s
sapient9415343sapient_
sarments10311963sarments
sateens73710753sateen_s
satiety1038203satie_ty
satinet7325283satinet_
satins64930483sati_n_s
sentients948463sentients
stents65019453_st_ents
stints65119763_sti_nts
taints64520533ta_i_nts
talents7312013ta_lents
tangents938713tangents
tents56434213__t_ents
tints56030923__ti_nts
valiants1137793valiants
variants1139203variants
varments1339063varments

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461622117.78018786.9
3Display Results2112110.0932268.8
 (SQL Overall)1786912118.29621539.4
 
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.