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

131 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
particles133980(None) 
articles10310241_articles
particle1239531particle_
article9310922_article_
articled1137062_articled
canticles1339182canticles
panicles121010112pa_nicles
pantiles103617152panti_les
partials101911962partial_s
partible1238062partible_
participles1773262participles
parties93230862parti__es
pastiches1637452pastiches
pastilles1148702pastilles
porticoes1348252porticoes
artistes83213343_artistes
auricles10138333_auricles
barbicels15113513barbicels
barnacles1355333barnacles
bastiles10313353basti_les
bastilles1147363bastilles
bernicles1345403bernicles
calicles123811433ca_licles
canticle1239703canticle_
carices114220953car_ic_es
carioles10817073car_ioles
carrioles1169473carrioles
caruncles1345003caruncles
caulicles1344383caulicles
cornicles1368243cornicles
cortices12615013cortic_es
curricles13105423curricles
cuticles1237893_cuticles
darioles9710693dar_ioles
dartles84014133dart__les
denticles1237753denticles
fascicles1664263fascicles
graticules13104363graticules
latices9313763la_tic_es
lattices1038383lattic_es
mastiches1647333mastiches
matrices12312083matric_es
mortices12711563mortic_es
nargiles976793nargi_les
panicle11129983pa_nicle_
panicled13106783pa_nicled
panties94230933panti__es
pantile93918483panti_le_
pantiled113111593panti_led
pantofles1474863pantofles
parables121613563par_ables
parbuckles2051913parbuckles
parcels113712663par__cels
parches143720003par__ches
paretics122312443paretic__s
paries84742513par_i__es
parietes10714543par_ietes
parises94827183par_i_ses
parishes13314753par_ishes
parities10522973par_ities
parles86334403par___les
paroles95025883par__oles
parricides1545553parricides
parridges1384553parridges
parries93925843parri__es
parritches1743223parritches
partakes1449923part_akes
parterres1148063parterres
partial92616263partial__
partially1449033partially
participle1683593participle_
particular1457553particular
particulars1566573particulars
particulates1647363particulates
partied103516553parti__ed
partier93520713parti__er
partiers103514243parti_ers
partings113513733parti_ngs
partisans1167483partisans
partitas10310253parti_tas
partite9317133parti_te_
partitives1546623partitives
partizans2055243partizans
partlet92720363part__let
partlets102811513part__lets
partridges1453053partridges
parvises133911913parvi_ses
pastiche1546933pastiche_
pasties94529813pasti__es
pastille1038943pastille_
pastils94416173pasti_l_s
pastimes123611903pasti_mes
pastises103616053pasti_ses
patches143320383pa_t_ches
patines95225763pa_ti_nes
patriates11311363patriates
patricides1546283patricides
patties93425143patti__es
pedicles1338683p_edicles
pellicles1344923pellicles
pentacles1338773pentacles
petioles10311643p_etioles
popsicles1543663popsicles
portables1337873portables
portholes14410373portholes
porticoed1445423porticoed
porticos1238373portic_os
portieres1138213portieres
postiches1648223postiches
potiches1539203p_otiches
practices1557993practic_es
pratincoles1552473pratincoles
pratiques20114213pratiques
prattles10189403prat_tles
prices104524543p_r_ic_es
prickles162511093p_r_ickles
quartiles1845603quarti_les
radicles11249703ra_dicles
reticles103912483_reticles
sanicles10149943sa_nicles
surtitles945633surtitles
testicles1146773testicles
utricles1037223utr_icles
varices123313573var_ic_es
varioles11711123var_ioles
vernicles1446133vernicles
versicles1446353versicles
vertices13612283vertic_es
vortices1369123vortic_es
wartimes1336963warti_mes
wavicles1633783wa_vicles

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411317.45319943.8
3Display Results1311310.0632079.4
 (SQL Overall)1786911317.93622516.5
 
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.