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

102 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
parterre103701(None) 
parterres1148081parterres
barterer102711652barterer
palterer102411292palterer
patterer103112182patterer
alterer72714013_alterer
arteries8321513_arteries
artery9911453_arte_ry
banterer102811783banterer
barberry1544873barberry
barter85525383barte_r_
bartered113113033bartered
barterers11269643barterers
barters94223053barte_rs
batterer102713223batterer
batterie10711543batterie
careerer1038583careerer
carter84932273carte_r_
carters95327263carte_rs
caterer92815953ca_terer
charterer14197333charterer
darter75320363darte_r_
darters84017613darte_rs
falterer11239873falterer
garter74420513garte_r_
gartered10319603gartered
garters84218253garte_rs
haltere103614713halte_re
palter84423263palte_r_
paltered113012503paltered
palterers11249543palterers
palters94021683palte_rs
pamperer14228333pamperer
panderer112210913panderer
paperer113111903pa_perer
papeterie1345193papeterie
parcener1238473parcener
pardee93922023parde__e
pareira937543par_eira
parer75839903par_e_r_
parerga1035173par_erga
parers85530743par_e_rs
pareve114613013par_e_ve
parker124121373parke_r_
parkers133816873parke_rs
parkette14138023parkette
parleyer1335633parleyer
parser84822373parse_r_
parsers94118153parse_rs
partake1339643part_ake
partaker1436873partaker
parted94228683parte__d
partible1238073partible
particle1239543particle
partier93520713partier_
partiers103514253partiers
partite9317133part_ite
partner92811393partner_
partnered1244493partnered
partners102711143partners
partyer12337873partyer_
partyers13277763partyers
parure8312523par__ure
parvenue1344933parvenue
paster85734373paste_r_
pastern94415063paste_rn
pasterns104112623pasterns
pasters94531733paste_rs
pasture9311463past_ure
pasturer1037523pasturer
pater74740723pa_te_r_
paters84935833pa_te_rs
pattee84323383patte__e
patter84628263patte_r_
pattered112714213pattered
patterers112410133patterers
pattern93712053patte_rn
patterned1265753patterned
patterns10439943patterns
patters94825193patte_rs
pearter9412743pearte_r_
perter84422283perte_r_
perverse1336103perverse
pesterer102412713pesterer
pewterer13256313pewterer
plasterer1178113plasterer
porter84224413porte_r_
porterage1245773porterage
portered112311553portered
porters93722703porte_rs
portiere1038773portiere
potterer102310263potterer
prater84825353prate_r_
praters94921653prate_rs
putterer10209913putterer
quarterer18145723quarterer
sauterne846253sauterne
sparteine1185483sparteine
tartare73012683tart_are
tarter64023563tarte_r_
wasterie111211593wasterie
waterer103314083wa_terer

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.483369960.7
2DLD Change Limit1461621026.98620922.1
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.51523777.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.