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

103 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
portieres113821(None) 
portiere1038771portiere_
partiers103514242partier_s
portered112311542port_ered
porteress1137932port_eress
porters93722702port_er_s
porticoes1348252porticoes
corsetieres1352893corsetieres
corteges1198823cort_eges
cortexes1797613cort_exes
cortices12615013corti_ces
cottiers10399153cottier_s
courtiers1146693courtier_s
derrieres1044813derrieres
forties104323863forti__es
fortieths1542783fortieths
fortifies1548693fortifies
mortices12711563morti_ces
mortifies1439393mortifies
mortisers1186163mortiser_s
mortises10713613morti_ses
northerns1244933northerns
northers1139333norther_s
parietes10714543par_ietes
parriers103612903parrier_s
parterres1148063parterres
particles1339803particles
partier93520713partier__
parties93230863parti__es
partnered1244483partnered
partners102711133partner_s
partyers13277763partyer_s
pitiers93812653p_itier_s
podomeres1445723podomeres
poetisers1145303poetiser_s
poetises10313953poeti_ses
poetizers2045103poetizer_s
poetizes19310253poeti_zes
porgies103017003porgi__es
porkers134314933por_ker_s
porkier133712343porkier__
porkies133416493porki__es
pornier93413133pornier__
porridges1343913porridges
portables1337873portables
portages112613223port_ages
portances1349833portances
portends11358963port_ends
portents103512823port_ents
porter84224413port_er__
porterages1345973port_erages
portholes14410373portholes
porticoed1445423porticoed
porticos1238373porti_cos
portioned1248333portioned
portioner1158683portioner
portioners1257413portioners
portions10514413porti_ons
portless10310643portle_ss
portlier1038373portlier__
portress1038323portre_ss
portresses1247313portresses
posterns102713723post_erns
posters93928013post_er_s
postiches1648223postiches
posties93128813posti__es
postiques2045833postiques
postures10313783post_ures
potherbs15387123po_therbs
pothered142311043po_thered
pothers123818623po_ther_s
potiches1539203po_tiches
pottered112311663po_ttered
potterer102310263po_tterer
potterers11218663po_tterers
potteries11313593po_tteries
potters94024343po_tter_s
pottier93516493pottier__
potties93723543potti__es
potzers184010543po_tzer_s
pouters94221873pout_er_s
poutier93215323poutier__
poutines102415103pouti_nes
powters124015663powt_er_s
premieres13288233premieres
priers84521193p_r_ier_s
priseres10310823p_riseres
proteges1149923prot_eges
proteides12238783proteides
protheses1449073protheses
purtier93214093purtier__
puttiers10288013puttier_s
sorters74221133sort_er_s
sorties74126403sorti__es
sortileges1152743sortileges
sporters103714063sport_er_s
sportier102010053sportier__
torcheres1446863torcheres
torchieres1543243torchieres
tortures838913tort_ures
vortexes18114053vort_exes
vortices1369123vorti_ces
worriers11257813worrier_s

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411038.04618473.9
3Display Results1031030.0462239.1
 (SQL Overall)1786911038.51520985.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.