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

158 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
pause7502183(None) 
cause75225351cause
paise75028331paise
parse75236991parse
pase65346861pa_se
passe75525691passe
paused95114961paused
pauser84415961pauser
pauses84621471pauses
abuse77119562abuse
amuse75920832amuse
apse67725382_apse
arse46539272_arse
base64847022ba_se
bouse75931852bouse
carse74934332carse
case65848082ca_se
caused95117042caused
causer84117782causer
causes88026472causes
causey113513272causey
cayuse11207762cayuse
clause84311502clause
cruse75726102cruse
daube85015302daube
douse66329722douse
druse64817662druse
ease45042332ea_se
false84818122false
fauve114712072fauve
fuse76429992_fuse
gauge76117902gauge
gauss65613452gauss
gauze155712972gauze
hanse85722792hanse
hausen9610382hausen
haute89521612haute
hawse116015122hawse
house89131422house
lapse74917682lapse
lase46148512la_se
louse56131012louse
manse75528222manse
marse76231152marse
masse75125292masse
mauve104013272mauve
mouse77133002mouse
muse67136032_muse
nausea637312nausea
pace86345772pa_ce
paces96741112paces
pacs85842182pacs_
padle84522342padle
padre86018162padre
pads76742952pads_
page76036102pa_ge
pages85235072pages
paisa76021072paisa
pale66055012pa_le
pales75753802pales
pals66951352pals_
palsy105417462palsy
pams85641762pams_
pane64950282pa_ne
panes76148692panes
panne76623652panne
pans65855722pans_
pansy105717972pansy
paps86443452paps_
papule102212132papule
parae76335702parae
pare66760842pa_re
pares77164482pares
parge85831852parge
parle75836162parle
pars67560792pars_
parsec105914472parsec
parsed96323892parsed
parser84822372parser
parses85534702parses
parure8312522parure
parve109824852parve
pas58775742pa_s_
paseo77022512pa_seo
pases75346502pa_ses
pash95638132pa_sh
pass65239952pa_ss
passed94320942passed
passee84522022passee
passel85117002passel
passer84721032passer
passes86030472passes
past65959012pa_st
paste74932952paste
pate65350462pa_te
pates76047892pates
pats66460852pats_
patsy105717202patsy
pauper103511942pauper
pausal81511962pausal
pausers94113222pausers
pave96133892pa_ve
paves104833922paves
pavise114714802pavise
paws96038182paws_
paxes144928422paxes
payee105524722payee
pays95940222pays_
pease75231112pease
peise75825772peise
perse75429522perse
peruse84016842peruse
phase104617212phase
plume94819462plume
plus66324832plus_
pluses83618072pluses
plush105614712plush
poise75127892poise
pose66441732p_ose
posse74722272posse
praise84419412praise
prase76128752prase
praus74621752praus_
prese75228382prese
prise74632612prise
prose75835122prose
prude84615972prude
prune75119632prune
puce85127882p_uce
puke105025462p_uke
pule65040952p_ule
pulse74219972pulse
pure65543332p_ure
purse76028892purse
pus55547842p_us_
puses75532202p_uses
push95526622p_ush
puss64830132p_uss
raise54828052raise
rase46149982ra_se
reuse56025362reuse
rouse56634702rouse
ruse45938932_ruse
sauce75121652sauce
saute55028082saute
souse56530772souse
sparse84516342sparse
spouse84112512spouse
tasse54821842tasse
taupe7314162taupe
taus46342732taus_
tawse85616502tawse
touse55430672touse
use36835162__use
valse85117522valse
vase75629652va_se
vaus75928922vaus_
youse85322232youse

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.0802233637.5
2DLD Change Limit538001581.81029723.8
3Display Results1581580.0334787.9
 (SQL Overall)1786911581.92392923.0
 
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.