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

375 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
porisms11371345(None) 
porism104518061porism_
prisms104915501p_risms
purisms114110831purisms
aorists74215832aorists
aphorisms1647192aphorisms
chrisms1499142chrisms
eonisms92811042eonisms
holisms123811112holisms
iodisms10308482iodisms
lorises73918592lorises
lyrisms1235652lyrisms
momisms10308222momisms
monisms113512802monisms
nomisms11268742nomisms
ogrisms1036442ogrisms
papisms13238542papisms
parises94827182parises
peonisms1238442peonisms
podiums12227632podiums
poises84226542po_ises
prims95425932p_ri_ms
prises84133172p_rises
prism94820262p_rism_
priss74623892p_ris_s
purism104715062purism_
purists94014072purists
tourisms1037612tourisms
verisms123011252verisms
ageisms1056603ageisms
agisms9399393_agisms
algorisms1246173algorisms
amorists10411333amorists
aorist64827873aoris_t
aphorises14310003aphorises
aphorism1548643aphorism_
aphorists1448263aphorists
aporias9315153apori_as
apprises12310963apprises
arises65233803_arises
arrises71617583arrises
atomisms12269573atomisms
atriums939043atriums
aurists74615783aurists
autisms94311553autisms
bariums1139143bariums
bogyisms1643823bogyisms
bohriums1593923bohriums
borides10515153borides
borings103614243borings
bossisms1244703bossisms
boyarisms1645443boyarisms
brims94721623_bri_ms
brises84927613_brises
brisks124611403_brisks
briss75824273_bris_s
bromisms1436403bromisms
cerises94722253cerises
ceriums1139473ceriums
charisms15710263charisms
chrism13710673chrism_
chrisma1456823chrisma
chrisoms1566093chrisoms
civisms1436073civisms
clonisms1237793clonisms
colorisms132810793colorisms
coniums11311863coniums
corium10315723corium_
corms95626223cor__ms
corpses113913803corpses
corses84433463cor_ses
cosmisms1446223cosmisms
crises84529433_crises
crisis83716343_crisis
crisps104411513_crisps
cubisms13306883cubisms
curiums1138503curiums
czarisms2155753czarisms
deisms94411043_deisms
dodoisms1244523dodoisms
dories75232363dori_es
dorms85723843dor__ms
egoisms1065953egoisms
egotisms1146683egotisms
emporiums1544223emporiums
eonism83213533eonism_
erotisms10310163erotisms
exorcisms2044863exorcisms
exotisms1746723exotisms
favisms1535443favisms
florists1138813florists
fogyisms1743283fogyisms
foists95413983fo_ists
foliums1237173foliums
forams115115913for_ams
forests104114953forests
forints10411833forints
forms105327053for__ms
forums114611843for_ums
frises94124273_frises
frisks13479263_frisks
gorms85619593gor__ms
gorses74723293gor_ses
grists74716483_grists
heroisms1338693heroisms
hoboisms1545563hoboisms
hoises94823673ho_ises
hoists95516023ho_ists
holism113713753holism_
holists104413963holists
hornists11208833hornists
horses94729343hor_ses
horsts95817513hor_sts
idolisms1146353idolisms
iodises83413633iodises
iodism93611133iodism_
ionises72916433ionises
ioniums938303ioniums
irises64221173_irises
isms66213473___isms
jisms14458003__jisms
joists134711033jo_ists
jorams154810533jor_ams
jorums15408093jor_ums
jurists14409123jurists
krises105016083_krises
locoisms1256143locoisms
lookisms1444793lookisms
lories64933043lori_es
loris55329153lori__s
lyrism1137473lyrism_
lyrists1036963lyrists
merises93421423merises
merisis93213173merisis
mobbisms1643773mobbisms
momism93410353momism_
monism104016313monism_
monists93614783monists
moralisms13410293moralisms
morass84614503moras_s
morions94014643morions
moronisms1348173moronisms
morrises10711073morrises
mortises10713613mortises
mutisms11338453mutisms
nanisms938833nanisms
narcisms1267263narcisms
nephrisms1644433nephrisms
nepotisms1355393nepotisms
noises65021853no_ises
nomism103010953nomism_
norias65518203nori_as
noris54928273nori__s
norites74018803norites
norms76019313nor__ms
nudisms10305853nudisms
obiisms1135673obiisms
odists749853_odists
odiums9337943_odiums
ogreisms1144113ogreisms
ogrism937913ogrism_
opiums10307073_opiums
oralisms10610973_oralisms
orgasms1054293_orgasms
oribis838833_oribis
oriels64914623_oriels
orisha936773_orisha
orishas1036473_orishas
orison6411663_orison
orisons7310563_orisons
orphisms1545993_orphisms
orrises71312233orrises
oxims14107643_oxi_ms
paisas84317493p_aisas
papism122211513papism_
papists112110453papists
parecisms1547163parecisms
pareses94718883pareses
paresis93315093paresis
pariahs123812343pariahs
parians93519733parians
paries84742513pari_es
parings104219213parings
paris75145943pari__s
parish115022353paris_h
parishes13314753parishes
parses85534703par_ses
parvises133911913parvises
pavises125315493pavises
peises84125043p_eises
penises9318193penises
peonism11611103peonism_
perils84121853peri_ls
periods10312243periods
peris75537073peri__s
perish114619063peris_h
perishes13313753perishes
peritus9311803peritus
perms95524513per__ms
perses85428063per_ses
persists1049183persists
peruses94018163peruses
phrases12711463phrases
pianisms1249013pianisms
pietisms1247463pietisms
pisos76021063p__isos
piss65033333p__is_s
plasms103711333p_lasms
plenisms1237963plenisms
podites103014733podites
podium112911913podium_
poems95715553po__ems
poesies93217403poesies
poetises10313953poetises
pogies94123543pogi_es
pogroms1237643pogroms
poilus82210573po_ilus
poinds93511143po_inds
points85618533po_ints
pois66539043po_i__s
poise75127893po_is_e
poised94918473po_ised
poiser84217243po_iser
poisers94214433po_isers
poisha1135723po_isha
poison8312223po_ison
poisons9310353po_isons
pokies125921333poki_es
polarises11514073polarises
polices113118053polices
polies84034583poli_es
polios84019723poli_os
polis74731163poli__s
polish114916723polis_h
polishes13711783polishes
pollists10910823pollists
poloists10910523poloists
pompoms1535333pompoms
poms87037743po___ms
ponies84833463poni_es
pooris83916843poori__s
poorish123712303pooris_h
popish133812113popis_h
popsies112816463popsies
populisms1545193populisms
porches143815673porches
porcinis1246953porcinis
pores75849033por__es
porgies103017003porgies
poring94227273pori_ng
porkers134314933porkers
porkies133416493porkies
porks115124143por__ks
pornos85015253por_nos
porns75527343por__ns
porose84818743poros_e
porous84419483por_ous
porpoises1348433porpoises
portals94015563portals
porters93722703porters
porticos1238373porticos
portions10514413portions
ports75934593por__ts
poses74642763po__ses
posies84431433posi_es
posits85718713posi_ts
posses85128803po_sses
possums1145753possums
posts75228783po__sts
potions93417423potions
potsies93019483potsies
praams10459643p_raams
praises94121103praises
prams96125513p_r_ams
prases84429023p_rases
press75425953p_res_s
prests84021263p_rests
prices104524543p_rices
pricks144414263p_ricks
prides94324183p_rides
priers84521193p_riers
pries74339533p_ri_es
priests93810863p_riests
prigs85219703p_ri_gs
prills84015613p_rills
prim85132203p_ri_m_
prima95019343p_ri_ma
primas104418103p_rimas
prime96525603p_ri_me
primes104225263p_rimes
primi95017403p_ri_mi
primo95017913p_ri_mo
primos104514423p_rimos
primp115615923p_ri_mp
primps124711823p_rimps
primus103712173p_rimus
prinks124315383p_rinks
prints84320103p_rints
prions84317783p_rions
priors83914483p_riors
prise74632613p_ris_e
prised94322203p_rised
prison8514023p_rison
prisons9313223p_risons
prisses94816713p_risses
prissy11347853p_rissy
prizes173819813p_rizes
proems104711163p_roems
promises122916763promises
proms95426413p_r_oms
prosaisms1346273prosaisms
proses84733473p_roses
prosos85718553p_rosos
pross76529403p_ros_s
prosses94019513prosses
protists10313363protists
protiums1238553protiums
provisos1336913provisos
psoriases1144863psoriases
psoriasis1143853psoriasis
purines94420763purines
purins83722653puri_ns
puris75332023puri__s
purist85525053puris_t
purses84826373pur_ses
pyrites12812203pyrites
pyrosis12411653pyrosis
racisms112310813racisms
rerises73525883rerises
rigorisms1245003rigorisms
rims65936303__ri_ms
rises55244043__rises
risks94917063__risks
risus54216393__risus
sadisms10359113sadisms
schisms1437173schisms
scrims104615933scri_ms
seisms84912143_seisms
sexisms16226223sexisms
sodiums10177213sodiums
solarisms1168813solarisms
sophisms1546653sophisms
sorings83817253sorings
sorites73825243sorites
soroses73117483soroses
sorosis72611973sorosis
theisms1237763theisms
thoriums13166403thoriums
torics85118353tori_cs
tories65435883tori_es
torses64727953tor_ses
torsks10549123tor_sks
torsos64815733tor_sos
tourism939423tourism_
tourists838313tourists
trims75021473_tri_ms
trismus935563_trismus
tropisms1247723tropisms
truisms9106823truisms
tsarisms1056653tsarisms
tzarisms1965213tzarisms
uprises92012733uprises
utopisms1245413utopisms
vaporises14209453vaporises
verism113214263verism_
verismo12276393verismo
verismos13284693verismos
verists103613673verists
wholisms1665253wholisms
worms105320763wor__ms
worses95522953wor_ses
worsts96014333wor_sts
wrists95415643_wrists
zorils153810883zori_ls
zoris145320013zori__s

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340273756.31321230.3
3Display Results3753750.1402678.6
 (SQL Overall)1786913756.85926052.0
 
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.