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

135 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
particle123953(None) 
article9310921_article
partible1238061partible
particles1339801particles
articled1137062_articled
articles10310242_articles
canticle1239702canticle
panicle11129982pa_nicle
pantile93918482panti_le
partial92616262partial_
partials101911952partials
participle1683592participle
partite9317132parti_te
pastiche1546932pastiche
pastille1038942pastille
anticly12410053_anticly
artily92814713_arti_ly
artiste73813693_artiste
auricle9139813_auricle
barbicel14144963barbicel
barnacle1245943barnacle
bastile9313913basti_le
bastille1047993bastille
bernicle1245443bernicle
calicle113111433ca_licle
canticles1339183canticles
cariole9818343car_iole
carriole1089863carriole
cartable121314093cartable
caruncle1244713caruncle
caulicle1245043caulicle
cornicle1258783cornicle
curricle12145933curricle
cuticle1138233_cuticle
dariole8711163dar_iole
dartle73714833dart__le
denticle1137773denticle
fascicle1554633fascicle
fertile10311733ferti_le
graticule1254573graticule
impartible1644363impartible
lattice938433lattic_e
martial92415413martial_
mastiche1547173mastiche
mortice11711493mortic_e
nargile847653nargi_le
panicled13106783pa_nicled
panicles121010113pa_nicles
pantie84326473panti__e
pantiled113111593panti_led
pantiles103617153panti_les
pantofle1364553pantofle
parable111819773par_able
parbuckle1942103parbuckle
parcel103915473par__cel
pardie96021443pardi__e
pardine103616723pardi_ne
paretic113016673paretic__
paretics122312443paretic_s
parle75836163par___le
parole84425253par__ole
parotic112518043parotic__
parricide1445753parricide
parridge1254333parridge
parsable12311693parsable
partake1339643part_ake
parterre1036983parterre
partially1449033partially
participles1773263participles
particular1457553particular
particulate1548313particulate
partied103516553parti_ed
partier93520713parti_er
partiers103514243partiers
parties93230863parti_es
parting103527383parti_ng
partings113513733partings
partisan1058423partisan
partita9310863parti_ta
partitas10310253partitas
partitive1447373partitive
partizan1955643partizan
partlet92720363part__let
partly116315473part__ly
partridge1362863partridge
parvise124211693parvi_se
passible1237693passible
pasticci1443823pasticci
pastiches1637453pastiches
pastie85525523pasti__e
pastil85018323pasti_l_
pastilles1148703pastilles
pastils94416173pasti_ls
pastime114611973pasti_me
patinae95414403pa_tinae
patine85328123pa_ti_ne
patriate10311933patriate
patricide1446613patricide
pattie84020963patti__e
pedicle1238973p_edicle
pellicle1245043pellicle
pentacle1239383pentacle
petiole9311303p_etiole
plasticly1644763plasticly
popsicle1443653popsicle
portable12313203portable
porthole1349523porthole
portico11310143portic_o
porticoed1445423porticoed
porticoes1348253porticoes
porticos1238373porticos
portiere1038773portiere
postiche1547793postiche
potiche1438043p_otiche
practice1438733practic_e
pratincole1452513pratincole
pratique19134283pratique
prattle9208833prat_tle
price93725413p_r_ic_e
prickle153611013p_r_ickle
quartile1747043quarti_le
radicle103510713ra_dicle
reticle94112623_reticle
sanicle91210263sa_nicle
surtitle845283surtitle
tactile9310613tacti_le
tartily103511573tarti_ly
testicle1037443testicle
tortile7313193torti_le
utricle937913utr_icle
variole10711593var_iole
vernicle1346433vernicle
versicle1366583versicle
wartime1237743warti_me
wavicle1534063wa_vicle

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621357.09320606.5
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.56223630.1
 
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.