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

275 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
prissies10171200(None) 
prisses94816711priss_es
prissier10157871prissier
prissiest11178901prissiest
prossies101515221prossies
brassies103613532brassies
brisses94314312briss_es
cissies94116152_cissies
hissies103915822_hissies
missies93423982_missies
pisses84525082p_iss_es
pliskies1475972pliskies
plisses94411772pliss_es
poussies1038112poussies
presses93523152press_es
primsie1137542primsie_
priories10312452priories
priseres10310822priseres
prises84133172pri_s_es
prissed103311262priss_ed
prissily1346692prissily
prissiness1266132prissiness
prissing113011452prissing
privies122414262pri_vies
prosses94019512pross_es
prossie91812952prossie_
prosties101421192prosties
pussies93615692p_ussies
sissies73716602_sissies
argosies939523argosies
arises65233803ari_s_es
bhisties1339003bhisties
blisses94911513bliss_es
bossies94116833_bossies
brasses93818353brass_es
brassie93411523brassie_
brassier103310533brassier
brassiest11369713brassiest
brinies93317913bri_nies
brionies10310543brionies
brises84927613bri_s_es
bristles101510433bristles
christies1449263christies
cresses94219813cress_es
crises84529433cri_s_es
crisis83716343cri_si_s
crispier12297253crispier
crispiest13197423crispiest
crosses94220793cross_es
crossties1139013crossties
cuisses9319883cuiss_es
daisies84217093dai_sies
dassies84418663_dassies
disses75225963_diss_es
dresses83716173dress_es
dressier956863dressier
dressiest1036823dressiest
dropsies1138693dropsies
droskies13186343droskies
drosses84513823dross_es
drossier956313drossier
drossiest1036523drossiest
eristics10610193eristics
flimsies1335783flimsies
flossies112810123flossies
frasses104314513frass_es
friaries11310083friaries
frisbees13295013frisbees
frisees104411693fri_sees
frises94124273fri_s_es
friskier1535193friskier
friskiest1636233friskiest
frissons1145043frissons
frizzies19315933frizzies
gipsies1039903_gipsies
glassies94012273glassies
glossies93311253glossies
grasses84117343grass_es
grassier9349283grassier
grassiest10309513grassiest
grilses8319153grils_es
griskins1335953griskins
grislier935793grislier
grisliest1047353grisliest
gristles9189203gristles
grosses84517683gross_es
gussies82813303_gussies
hisses94719353_hiss_es
hissier103410503_hissier
hissiest112911093_hissiest
hussies103213293_hussies
irises64221173iri_s_es
iritises839973iritises
isseis638563__isseis
issues648803__issues
kisses104217333_kiss_es
krises105016083kri_s_es
lassies74420103_lassies
mislies92922283_mislies
misses85130873_miss_es
missiles103015083_missiles
missis84417503_missi_s
missises103513693_missises
missives133212843_missives
palsies94420273p_alsies
pansies94521983p_ansies
parises94827183pari_s_es
parishes13314753pari_shes
parities10522973pari_ties
passes86030473p_ass_es
passives13228823p_assives
pasties94529813p_asties
patissier1143183patissier
patissiers1242123patissiers
patsies93919483p_atsies
pavisses13397103paviss_es
peises84125043pei_s_es
pelisses1048483peliss_es
perishes13313753peri_shes
phrensies1445743phrensies
pieties9419223p_ieties
piggies113813483p_iggies
pigmies122610993p_igmies
pigsties1139783pigsties
pinkies133818263p_inkies
pinnies93318443p_innies
piracies12312643piracies
pirogies1139423pirogies
pishes114722103p_i_shes
pismires1235883p_ismires
pissed94816933p_iss_ed
pisser84416383p_iss_er
pissers95014753p_issers
pissing103914803p_issing
pissoirs1044693p_issoirs
pistes85325633p_i_stes
pistils93314303p_istils
pities83828083p_i_ties
pixies154915513p_i_xies
pliskie1394543pliskie_
plisse8368403pliss_e_
plusses93510693pluss_es
poesies93217403p_oesies
poises84226543poi_s_es
popsies112816463p_opsies
posies84431433p__osies
posses85128803p_oss_es
posties93128813p_osties
potsies93019483p_otsies
poussie936623poussie_
prairies10411453prairies
praises94121103prais_es
prases84429023pr_as_es
praxises1739063praxises
precises123218333precises
predries112714383predries
preemies12512193preemies
premies113823063pr_emies
premises123018273premises
premisses13288763premiss_es
preppies1149683preppies
presages11312203presages
presales10315263presales
preships1539313preships
presides11414913presides
preslices1338213preslices
pressed103317313press_ed
presser93717623press_er
pressers103215023pressers
pressing112516443pressing
pressings12269023pressings
pressmen1238833pressmen
pressors103212683pressors
pressures1149063pressures
prestiges12310593prestiges
presumes1239843presumes
pretties10615133pretties
previses133814283previses
prexies163415003pr_exies
prices104524543pri__ces
pricier113313113pri_cier
priciest122112903pri_ciest
prickier16368143prickier
prickiest1748183prickiest
prickles162511093prickles
prides94324183pri__des
priedieu1153983priedieu
priedieus1242943priedieus
pries74339533pr___ies
priested1138393priested
priestess1145293priestess
priests93810863pries_ts
primacies1548453primacies
primages13159273primages
primaries13410833primaries
primates121515933primates
primes104225263pri__mes
primines123013703primines
primuses1237083primuses
princes113015143pri_nces
prise74632613pri_s_e_
prised94322203pri_s_ed
prisere9310943prisere_
prising103321453pri_sing
prismoids1443613prismoids
prisms104915503pri_s_ms
prisoned1138813prisoned
prisoner1048573prisoner
prisoners1147373prisoners
prisons9313223pri_sons
priss74623893pri_s__s
prissy11347853priss__y
pristanes11410433pristanes
pristine10313503pristine
privacies1646803privacies
privates131812373privates
privier122910453pri_vier
priviest132310313pri_viest
privities14312043privities
prizes173819813pri__zes
promises122916763promises
proses84733473pr_os_es
prosier93817483pr_osier
prosiest10416523pr_osiest
prosodies1249733prosodies
prostie91617743prostie_
proxies163014933pr_oxies
prussiates1244123prussiates
prussic1144743prussi_c
puisnes937423pui_snes
purifies13311923puri_fies
purities10316283puri_ties
pusses84322843p_uss_es
pussier93711993p_ussier
pussiest102911753p_ussiest
pusslies1036173pusslies
pyrosises1457583pyrosises
quinsies1737623quinsies
rassles73513923_rassles
reissues845993reissues
rinses64720383_rins_es
rises55244043_ri_s_es
rishis9312453_rishi_s
riskier1138423_riskier
riskiest12310133_riskiest
rissoles839113_rissoles
risuses73210923_risuses
sassies74719263_sassies
sisses64520603_siss_es
sissier73711363_sissier
sissiest83412353_sissiest
speisses10245693speiss_es
swisses10417143swiss_es
tassies74918933_tassies
tissues737463_tissues
trasses74819323trass_es
tresses73719543tress_es
tressier847963tressier
tressiest937883tressiest
trilbies1037693trilbies
trioses75015653trios_es
trisemes1036643trisemes
trisomes1039833trisomes
trisomies1147163trisomies
trusses73813643truss_es
trusties82712853trusties
uprises92012733upri_s_es
whimsies1635193whimsies
whiskies1835953whiskies
wisses94619603_wiss_es
wrasses103812593wrass_es
wrassles11376713wrassles
wristier1136863wristier
wristiest1237753wristiest
wussies103411083_wussies

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.1561145455.1
2DLD Change Limit1461622757.36019859.0
3Display Results2752750.1102500.0
 (SQL Overall)1786912757.62623431.8
 
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.