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 “prise” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

242 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
prise7463261(None) 
arise56436431arise
frise85322451frise
paise75028331paise
peise75825771peise
poise75127891poise
praise84419411praise
prase76128751prase
prese75228381prese
price93725411price
pride84724731pride
pries74339531pries
prime96525601prime
prised94322201prised
prises84133171prises
prism94820261prism
priss74623891priss
prize164718941prize
prose75835121prose
rise45945231_rise
uprise82313691uprise
anise55129702anise
apprise11310192apprise
ariose64818722ariose
arisen65316792arisen
arises65233802arises
arose55832082arose
arse46539272ar_se
birse74517402birse
bise66437102_bise
braise84318752braise
bribe94820782bribe
bride86425532bride
brie65837902bri_e
bries74942152bries
brine75132272brine
bris65539612bris_
brises84927612brises
brisk115615982brisk
briss75824272briss
brose75227032brose
bruise83412872bruise
cerise84822042cerise
cries75438402cries
crime94822692crime
cripe95521142cripe
cris66233432cris_
crises84529432crises
crisp95014622crisp
cruise84314042cruise
cruse75726102cruse
dries64733672dries
drive95318002drive
druse64817662druse
emprise11310722emprise
erase54925492erase
erose55727272erose
fraise94214912fraise
fries85535602fries
frisee94217992frisee
frises94124272frises
frisk125312372frisk
gride75223582gride
grilse7399502grilse
grime85021322grime
gripe84622962gripe
grist65529872grist
guise64717712guise
hoise85224772hoise
iris45732552iris_
irised73913152irised
irises64221172irises
kris86423602kris_
krises105016082krises
mise66043582_mise
noise55723732noise
paisa76021072paisa
paries84742512paries
paris75145942paris_
parises94827182parises
parish115022352parish
parse75236992parse
parvise124211692parvise
pase65346862p_ase
passe75525692passe
pause75021832pause
pavise114714802pavise
pease75231112pease
peised94817682peised
peises84125042peises
peris75537072peris_
perish114619062perish
perse75429522perse
peruse84016842peruse
phase104617212phase
phis95724902phis_
phrase11109902phrase
pice84641092p_ice
pie55457402p_i_e
pies66949602p_ies
pike106335212p_ike
pile65649692p_ile
pine67755712p_ine
pipe86434432p_ipe
pis56362032p_is_
pish96127912p_ish
piso66727562p_iso
piss65033332p_iss
piste75824602p_iste
plie65127392pli_e
plies74526512plies
plisse8368402plisse
pois66539042pois_
poised94918472poised
poiser84217242poiser
poises84226542poises
porism104518062porism
porose84818742porose
pose66441732p_ose
posse74722272posse
praised104214812praised
praiser93413942praiser
praises94121102praises
prases84429022prases
prate75135982prate
precise113518172precise
pree67044732pr_ee
prees75937172prees
premise113818552premise
presa74319042presa
preset84430982preset
press75425952press
prest75736352prest
previse123713792previse
priced115018882priced
pricer103918292pricer
prices104524542prices
pricey134412632pricey
prick134317502prick
pricy124814562pricy
prided103618032prided
prides94324182prides
pried84426862pried
prier75027762prier
priest84125422priest
prig75924872pri_g
prigs85219702prigs
prill74117942prill
prim85132202pri_m
prima95019342prima
primed115118912primed
primer105118682primer
primes104225262primes
primi95017402primi
primo95017912primo
primp115615922primp
prims95425932prims
primsie1137542primsie
prince104114762prince
prink114719672prink
print74837462print
prion75119992prion
prior74316172prior
prisere9310942prisere
prisms104915502prisms
prison8514022prison
prissed103311262prissed
prisses94816712prisses
prissy11347852prissy
privet113821342privet
privy13439832privy
prized184415392prized
prizer174714882prizer
prizes173819812prizes
probe94320812probe
prole74527792prole
promise113415842promise
prone75332622prone
pros65742782pros_
prosed94921092prosed
proser84223462proser
proses84733472proses
proso77222412proso
pross76529402pross
prost75434102prost
prosy106319252prosy
prove104823192prove
prude84615972prude
prune75119632prune
psis68120342psis_
puisne856352puisne
pulse74219972pulse
purine85321892purine
puris75332022puris_
purism104715062purism
purist85525052purist
purse76028892purse
pyrite11913312pyrite
raise54828052raise
rase46149982_rase
reprise92715042reprise
rerise64325632rerise
rice64942912_rice
ride55945132_ride
rife74632322_rife
rile45650532_rile
rime65138882_rime
rinse54820972_rinse
ripe66038922_ripe
risen54621882_risen
riser55431052_riser
rises55244042_rises
risk85724102_risk
rite45849452_rite
rive75537722_rive
rose46148902_rose
ruse45938932_ruse
seise54727852seise
speise84614252speise
sprite84421772sprite
sris45434152sris_
tribe74420272tribe
trice75127492trice
tries55742812tries
trike95320162trike
trine54734602trine
triose64715382triose
tripe75425382tripe
triste63818642triste
trite54730032trite
upraise9158602upraise
uprisen9227352uprisen
upriser9218762upriser
uprises92012732uprises
uprose82311482uprose
urase54624692urase
urine55026592urine
vise75632672_vise
wise75737342_wise
wries85827742wries
wrist84827562wrist
write85522832write

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538002421.58034050.6
3Display Results2422420.0803025.0
 (SQL Overall)1786912421.97090706.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.