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

166 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
peise7582577(None) 
paise75028331paise
pease75231111pease
peised94817681peised
peises84125041peises
perse75429521perse
poise75127891poise
prise74632611prise
seise54727851seise
speise84614251speise
anise55129702anise
arise56436432arise
beige81515372beige
betise85616272betise
bise66437102_bise
cease75227652cease
cense75121402cense
cerise84822042cerise
deice84320032deice
deism84116032deism
deist64633592deist
demise94618322demise
dense65923502dense
devise104215752devise
ease45042332_ease
eide55832232_eide
else45923082_else
fease84824872fease
feist86230072feist
fesse86116332fesse
frise85322452frise
geese64316002geese
guise64717712guise
heist87030912heist
hoise85224772hoise
jesse126012832jesse
lease55230262lease
leis45739602leis_
lense54523432lense
mense75025632mense
mise66043582_mise
neist54628442neist
noise55723732noise
paisa76021072paisa
parse75236992parse
pase65346862p_ase
passe75525692passe
pause75021832pause
pavise114714802pavise
peace95026082peace
peage84723562peage
peas65755062peas_
peasen84815962peasen
peases85229472peases
pecs84634102pecs_
pedes85327282pedes
peds75835242peds_
pee56066512pe__e
pees65257372pees_
peeve104915252peeve
pegs75531762pegs_
pehs95625762pehs_
pein65834942pei_n
peined94918842peined
peins76128062peins
peke105926202pe_ke
pekes114623562pekes
pekoe114612362pekoe
pele65539552pe_le
peles75738082peles
pelisse967062pelisse
pelite84323002pelite
pence94924452pence
penes75839222penes
penile82219602penile
penis75129322penis_
penises9318192penises
penne75423852penne
pens65649642pens_
pensee8417312pensee
peps85134512peps_
pere66450262pe_re
peres76246642peres
peris75537072peris_
perish114619062perish
perses85428062perses
peruse84016842peruse
pes57259782pe_s_
peso66925822pe_so
pest65555292pe_st
petite84320652petite
pets66248332pets_
pewee10319972pewee
pews95731532pews_
phase104617212phase
phis95724902phis_
pice84641092p_ice
pie55457402p_i_e
piece96717992piece
pies66949602pies_
pike106335212p_ike
pile65649692p_ile
pine67755712p_ine
pipe86434432p_ipe
pis56362032p_is_
pish96127912p_ish
piso66727562p_iso
piss65033332p_iss
piste75824602p_iste
please84315732please
plie65127392pli_e
plies74526512plies
plisse8368402plisse
poetise9314042poetise
pois66539042pois_
poised94918472poised
poiser84217242poiser
poises84226542poises
pose66441732p_ose
posse74722272posse
praise84419412praise
prase76128752prase
precise113518172precise
premise113818552premise
prese75228382prese
previse123713792previse
price93725412price
pride84724732pride
pries74339532pries
prime96525602prime
prised94322202prised
prises84133172prises
prism94820262prism
priss74623892priss
prize164718942prize
prose75835122prose
psis68120342psis_
puisne856352puisne
pulse74219972pulse
purse76028892purse
raise54828052raise
reis45343232reis_
reive85522942reive
remise84221952remise
rerise64325632rerise
reuse56025362reuse
revise94019742revise
rise45945232_rise
seine55732872seine
seis45542392seis_
seised74218122seised
seiser65318342seiser
seises64026712seises
seism75019022seism
seize143819502seize
sense55526822sense
speises93813932speises
speiss84311642speiss
spense83912432spense
tease55428712tease
tense55225842tense
terse55026822terse
uprise82313692uprise
verse84723582verse
vise75632672_vise
wise75737342_wise

Search took 3 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.0931921408.6
2DLD Change Limit538001661.81329674.6
3Display Results1661660.0463608.7
 (SQL Overall)1786911661.95291542.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.