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

250 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
priseres1031082(None) 
prisere9310941prisere_
frisees104411692frise_es
poisers94214432poiser_s
praisers103410832praiser_s
preserves14109072preserves
pricers113915062pricer_s
priers84521192pri_er_s
primeros12336882primeros
primers114215672primer_s
prises84133172pris__es
prisses94816712pris_ses
prissies101712002prissies
prizers183911842prizer_s
prosers94219642proser_s
risers64624782_riser_s
trisemes1036642trisemes
uprisers10206772upriser_s
apprisers1345053appriser_s
arises65233803aris__es
bistres94017213_bistres
boiseries11411053boiseries
bribees11409283bribe_es
briberies1348333briberies
bribers114111503briber_s
briers85319733bri_er_s
briners94315633briner_s
brises84927613bris__es
brisses94314313bris_ses
bristles101510433bristles
bruisers10307953bruiser_s
chimeres153511313chimeres
criers83918583cri_er_s
crises84529433cris__es
crispers12309443crisper_s
cruisers10438283cruiser_s
driers74516733dri_er_s
drivers114412793driver_s
droseras935883droseras
epimeres12117653epimeres
erasers74413943eraser_s
erasures837213erasures
freres94716173fr__eres
friers94718933fri_er_s
friezes19418913fri_ezes
frisbees13295013frisbees
frisee94217993frise_e_
frises94124273fris__es
frisettes1295353frisettes
friseurs1133303friseurs
friskers15337373frisker_s
frizers19329553frizer_s
grieves1137323gri_eves
gripers104011463griper_s
griseous945613griseous
grisettes1094713grisettes
gristers94013413grister_s
gristles9189203gristles
gruyeres1242863gruyeres
irises64221173iris__es
kaisers11369273kaiser_s
krises105016083kris__es
leisures836683leisures
miseries10320403_miseries
misers85025703_miser_s
parietes10714543pari_etes
parises94827183paris__es
parishes13314753paris_hes
parsers94118153parser_s
passers94717753passer_s
pausers94113223pauser_s
pavisers13387443paviser_s
peises84125043peis__es
pensees9311203pense_es
peres76246643p___eres
periderms1444993periderms
perigees1189503perige_es
perisarcs1344093perisarcs
perishes13313753peris_hes
perusers10328803peruser_s
pharisees1444633pharise_es
philtres1396513philtres
piastres10249303piastres
pieces104217273p_i_eces
pierces113411193p_i_erces
piers75926333p_i_er_s
pikers124717393p_iker_s
pinenes93416673p_inenes
pineries102419083p_ineries
pipers104318663p_iper_s
pishers123815753p_isher_s
pishes114722103p_is_hes
pismires1235883p_ismires
pissers95014753pisser_s
pisses84525083p_is_ses
pistes85325633p_is_tes
pliers84715153pli_er_s
pliskies1475973pliskies
plisses94411773plis_ses
poiser84217243poiser__
poises84226543pois__es
portieres1138223portieres
posers84223973p_oser_s
praiser93413943praiser__
praises94121103prais__es
prases84429023pras__es
praters94921653prater_s
prayers124212853prayer_s
precedes13310713precedes
precures12312903precures
prees75937173pr__e_es
prefers123713333prefer_s
prefires134313283prefires
preinserts1243973preinserts
premieres13288233premieres
prepares122014163prepares
presages11312203presages
presales10315263presales
prescores133912173prescores
presells1058283presells
presences132113793presences
presents103315643presents
preserve13108803preserve
preserved15107563preserved
preserver14127013preserver
preservers15115693preservers
presets94216423prese_ts
presides11414913presides
presorts105311683presorts
pressers103215023presser_s
presses93523153pres_ses
pressures1149063pressures
presters103419003prester_s
prestores114716083prestores
prestress1138133prestress
presumes1239843presumes
preterms1237223preterms
preverbs15295303preverbs
prewires133811013prewires
prexes154915953pr__exes
preyers124412363preyer_s
prezes173614693pr__ezes
priceless1336883priceless
pricer103918293pricer__
prices104524543pri__ces
prickers163710673pricker_s
prickles162511093prickles
prides94324183pri__des
prier75027763pri_er__
pries74339533pri___es
priested1138393priested
priestess1145293priestess
priests93810863pri_ests
priggeries1444993priggeries
primages13159273primages
primaries13410833primaries
primates121515933primates
primeness1338653primeness
primer105118683primer__
primero11368923primer_o
primes104225263pri__mes
primines123013703primines
primuses1237083primuses
princes113015143pri_nces
prinkers143010383prinker_s
printeries12410643printeries
printers103214903printer_s
prioress1035393prioress
priories10312453priories
priors83914483pri_or_s
prise74632613pris__e_
prised94322203pris__ed
prisms104915503pris__ms
prisoned1138813prisoned
prisoner1048573prisoner
prisoners1147373prisoners
prisons9313223pris_ons
priss74623893pris___s
prissed103311263pris_sed
prissier10157873prissier
prissiest11178903prissiest
pristanes11410433pristanes
privates131812373privates
privets122910053prive_ts
privies122414263pri_vies
prizer174714883prizer__
prizes173819813pri__zes
probers113514583prober_s
procures1239213procures
promisees13246863promise_es
promisers13268203promiser_s
propenes122816513propenes
properer1259203properer
properest1349663properest
propers113619033proper_s
prosects1239473prosects
proser84223463proser__
proses84733473pros__es
prospered1446973prospered
prospers123012263prosper_s
prosses94019513pros_ses
prossies101515233prossies
prosties101421193prosties
proteges1149923proteges
proverbs15315583proverbs
provers123817793prover_s
pruderies1247873pruderies
pruners93710723pruner_s
pryers115012243pr_yer_s
puisnes937423puis_nes
pulsers94213153pulser_s
pursers93916093purser_s
raisers73617393raiser_s
rasers64526783_raser_s
rasures7312013_rasures
resees63827483_rese_es
reserves111011983_reserves
reveres103621343_reveres
ricers84120993_ricer_s
riders74123903_rider_s
rimers84522553_rimer_s
rinsers73815743_rinser_s
riser55431053_riser__
rises55244043_ris__es
riskers114011993_risker_s
ristras7311563_ristras
risuses73210923_risuses
rivers94626543_river_s
rivieres1136013_rivieres
roseries8317323_roseries
seisers73816393seiser_s
seisures838273seisures
seres55448893___seres
subseres10312423subseres
trienes74118413tri_enes
triers64321523tri_er_s
trimers94615143trimer_s
triremes1035523triremes
trisceles1145293trisceles
trisects1035983trisects
triseme936543triseme_
triskeles1344273triskeles
trisomes1039833trisomes
unisexes1554613unisexes
upraisers11174423upraiser_s
upriser9218763upriser__
uprises92012733upris__es
uprivers13215563upriver_s
writers105513493writer_s
xeroseres1644683xeroseres

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.423422437.4
2DLD Change Limit1461622507.70318974.7
3Display Results2502500.1102272.7
 (SQL Overall)1786912508.23621696.3
 
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.