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

192 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
passe7552569(None) 
masse75125291masse
paise75028331paise
parse75236991parse
pase65346861pa_se
pases75346501pases
pass65239951pass_
passed94320941passed
passee84522021passee
passel85117001passel
passer84721031passer
passes86030471passes
paste74932951paste
pause75021831pause
posse74722271posse
tasse54821841tasse
apse67725382_apse
apses76823912apses
arse46539272_arse
ass37844062_ass_
asses55629282_asses
asset55932262_asset
base64847022ba_se
bases75644352bases
bass66146782bass_
basses85428302basses
basset85225382basset
bassi77019322bassi
basso76017282basso
bassy1012917102bassy
baste74829982baste
carse74934332carse
case65848082ca_se
cases75048382cases
caste75932362caste
cause75225352cause
chasse115114602chasse
dassie74615572dassie
ease45042332ea_se
eases56041612eases
false84818122false
fesse86116332fesse
fosse86119462fosse
gases65633992gases
gassed85217632gassed
gasser75017772gasser
gasses75724782gasses
gassy95514022gassy
hanse85722792hanse
hassel95614212hassel
hassle93711592hassle
haste85927862haste
hawse116015122hawse
impasse11246462impasse
jesse126012832jesse
lapse74917682lapse
lase46148512la_se
lases54944762lases
lass47444542lass_
lasses64827592lasses
lassi56316852lassi
lassie64917742lassie
lasso55015682lasso
manse75528222manse
marse76231152marse
mass66044932mass_
massa75518922massa
massed94421322massed
masses85028712masses
massy104518962massy
oases55330982oases
pace86345772pa_ce
paces96741112paces
pacs85842182pacs_
padle84522342padle
padre86018162padre
pads76742952pads_
page76036102pa_ge
pages85235072pages
paisa76021072paisa
pale66055012pa_le
pales75753802pales
pals66951352pals_
palsy105417462palsy
pams85641762pams_
pane64950282pa_ne
panes76148692panes
panne76623652panne
pans65855722pans_
pansy105717972pansy
paps86443452paps_
parae76335702parae
pare66760842pa_re
pares77164482pares
parge85831852parge
parle75836162parle
pars67560792pars_
parsec105914472parsec
parsed96323892parsed
parser84822372parser
parses85534702parses
parve109824852parve
pas58775742pa_s_
paseo77022512paseo
pash95638132pa_sh
pasha105417182pasha
pashed125923142pashed
pashes115828392pashes
passade1039232passade
passage1039802passage
passels93913022passels
passers94717752passers
passim10410282passim
passive12239592passive
passkey1633562passkey
passus83610292passus
past65959012pa_st
pasta76624532pasta
pasted94426902pasted
pastel85918712pastel
paster85734372paster
pastes85233912pastes
pastie85525522pastie
pasts75936502pasts
pasty105725052pasty
pate65350462pa_te
pates76047892pates
pats66460852pats_
patsy105717202patsy
paused95114962paused
pauser84415962pauser
pauses84621472pauses
pave96133892pa_ve
paves104833922paves
pavise114714802pavise
pavisse12546812pavisse
paws96038182paws_
paxes144928422paxes
payee105524722payee
pays95940222pays_
pease75231112pease
peases85229472peases
peise75825772peise
perse75429522perse
phase104617212phase
phases114618402phases
piss65033332piss_
pissed94816932pissed
pisser84416382pisser
pisses84525082pisses
piste75824602piste
plisse8368402plisse
poise75127892poise
pose66441732p_ose
poses74642762poses
posses85128802posses
posset84923252posset
praise84419412praise
prase76128752prase
prases84429022prases
prese75228382prese
prise74632612prise
prose75835122prose
psst66118402p_sst
pulse74219972pulse
purse76028892purse
puses75532202puses
puss64830132puss_
pusses84322842pusses
pussy105614842pussy
raise54828052raise
rase46149982ra_se
rases55447212rases
rassle63813202rassle
sass45035622sass_
sassed76116172sassed
sasses64124392sasses
sassy85813812sassy
sparse84516342sparse
tass45640572tass_
tassel66014772tassel
tasses64826762tasses
tasset65925312tasset
tassie66017022tassie
taste55127232taste
tawse85616502tawse
upases84112902upases
valse85117522valse
vase75629652va_se
vases84626262vases
waste86125052waste
wrasse9398772wrasse

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.0961861364.6
2DLD Change Limit538001921.87328724.0
3Display Results1921920.0633047.6
 (SQL Overall)1786911922.03287938.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.