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

182 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
portiere103877(None) 
portieres1138211portieres
partier93520712partier_
partiers103514242partiers
porkier133712342porkier_
pornier93413132pornier_
porter84224412port_er_
portered112311542port_ered
porters93722702port_ers
portlier1038372portlier_
pottier93516492pottier_
poutier93215322poutier_
purtier93214092purtier_
sportier102010052sportier_
artier63419733_artier_
corkier133114303corkier_
cornier93017093cornier_
corsetiere1253573corsetiere
cortege1098953cort_ege
cottier93814173cottier_
cottiers10399153cottiers
courtier1059333courtier_
courtiers1146693courtiers
derriere936043derriere
dirtier83312093dirtier_
dorkier122810023dorkier_
dotier73917033do_tier_
dottier83910923dottier_
footier104115113footier_
forkier144311593forkier_
forties104323863fortie_s
fortieth1445173fortieth
gorier73719373gor_ier_
gorsier83811073gorsier_
goutier82612353goutier_
hootier104915353hootier_
hornier103012463hornier_
horsier103013243horsier_
joltier14318493joltier_
loftier1037763loftier_
mortice11711493morti_ce
mortise9713533morti_se
mortiser1078473mortiser_
mortisers1186163mortisers
norther1039733norther_
northern1145583northern
northers1139333northers
orbier839993_orbier_
parrier93717653parrier_
parriers103612903parriers
parterre1036983parterre
partible1238063partible
particle1239533particle
partied103516553partie_d
parties93230863partie_s
partite9317133parti_te
partner92811393partner_
partnered1244483partnered
partners102711133partners
partyer12337873partyer_
partyers13277763partyers
pastier94320383pastier_
peatier94017233peatier_
perkier133813123perkier_
perter84422283pert_er_
pestier94317403pestier_
pettier94213613pettier_
pitier84019823p_itier_
pitiers93812653p_itiers
platier93716293platier_
plottier10327263plottier_
pockier153911603pockier_
podgier11338723podgier_
podomere1344993podomere
poetise9314043poeti_se
poetiser1037313poetiser_
poetisers1145303poetisers
poetize18310773poeti_ze
poetizer1936813poetizer_
poetizers2045103poetizers
pointier1038303pointier_
pokier124914633po_kier_
politer92417073politer_
pontine92419053ponti_ne
porcine11312843porci_ne
porgies103017003porgie_s
porker124917543por_ker_
porkers134314933por_kers
porkies133416493porkie_s
porkiest143513713porkiest
porniest103214313porniest
porridge1243763porridge
portable12313203portable
portage103013643port_age
portance12310123portance
ported94223243port_e_d
portend103411193port_end
portent93619643port_ent
porterage1245763port_erage
porteress1137933port_eress
porthole1349523porthole
portico11310143porti_co
porticoed1445423porticoed
porticoes1348253porticoes
porticos1238373porticos
porting103021783porti_ng
portion9615493porti_on
portioned1248333portioned
portioner1158683portioner
portioners1257413portioners
portions10514413portions
portless10310643portless
portliest11310183portliest
portress1038323portress
portside1138163portside
poster84129173post_er_
postern93615613post_ern
posters93928013post_ers
postfire1346273postfire
postiche1547793postiche
postie84123963posti__e
posties93128813postie_s
postique1945873postique
posture9313253post_ure
pother113818853po_ther_
potherb14358683po_therb
pothered142311043po_thered
pothers123818623po_thers
potiche1438043po_tiche
potter83926983po_tter_
pottered112311663po_ttered
potterer102310263po_tterer
potters94024343po_tters
pottery123011073po_ttery
potties93723543pottie_s
pottiest102815973pottiest
potzer174411213po_tzer_
potzers184010543po_tzers
pouter83923983pout_er_
pouters94221873pout_ers
poutiest103016793poutiest
poutine93316823pouti_ne
powter114116033powt_er_
powters124015663powt_ers
poxier153812113po_xier_
premiere12249233premiere
prier75027763p_r_ier_
priers84521193p_r_iers
prisere9310943p_risere
prosier93817483prosier_
protege1059153prot_ege
proteide11239723proteide
pursier94012753pursier_
purtiest102414113purtiest
puttier93314503puttier_
puttiers10288013puttiers
rootier74915393rootier_
sootier73916613sootier_
sorrier72313733sorrier_
sorter64425093sort_er_
sorters74221133sort_ers
sortie63621993sorti__e
sortied83314103sortie_d
sorties74126403sortie_s
sortilege1043033sortilege
sporter93616553sport_er_
sporters103714063sport_ers
sportiest111711033sportiest
sportive1348333sporti_ve
spottier10207313spottier_
tartier74123263tartier_
torchere1347683torchere
torchiere1443573torchiere
tortile7313193torti_le
torture738593tort_ure
wartier103413913wartier_
wordier112511213wordier_
wormier12278763wormier_
worrier102311683worrier_
worriers11257813worriers
worthier1436713worthier_
zootier163611173zootier_

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.500357382.0
2DLD Change Limit1461621828.08018089.4
3Display Results1821820.0931957.0
 (SQL Overall)1786911828.67320603.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.