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

131 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
paseo7702251(None) 
pareo74632601pareo
pase65346861pase_
paseos88015811paseos
pases75346501pases
apse67725382apse_
apses76823912apses
asea46327182_asea
base64847022base_
based85331582based
baser74828922baser
bases75644352bases
basso76017282basso
cameo95924992cameo
case65848082case_
cased86032412cased
cases75048382cases
ease45042332ease_
eased65430402eased
easel54521112easel
eases56041612eases
gases65633992gases
lase46148512lase_
lased65132342lased
laser54633322laser
lases54944762lases
lasso55015682lasso
maser75029972maser
oases55330982oases
pace86345772pace_
paced106931682paced
pacer96131612pacer
paces96741112paces
pacey126720282pacey
paeon74819492pa_eon
page76036102page_
paged95926782paged
pager84728202pager
pages85235072pages
paise75028332paise_
pale66055012pale_
palea75028662palea
paled85538722paled
paler75436932paler
pales75753802pales
palet74650802palet
pane64950282pane_
paned85437182paned
panel76023622panel
panes76148692panes
panto76129412panto
paper95128662paper
pare66760842pare_
pared86946762pared
pareos87023772pareos
parer75839902parer
pares77164482pares
pareu74928742pareu
pargo86723722pargo
parse75236992parse_
parsec105914482parsec
parsed96323892parsed
parser84822372parser
parses85534702parses
parvo107719182parvo
pas58775742pas__
pash95638132pas_h
pasha105417182pasha
pashed125923142pashed
pashes115828392pashes
pass65239952pas_s
passe75525692passe
passed94320942passed
passee84522022passee
passel85117002passel
passer84721032passer
passes86030472passes
past65959012pas_t
pasta76624532pasta
paste74932952paste
pasted94426902pasted
pastel85918712pastel
paster85734372paster
pastes85233912pastes
pastor84817482pastor
pasts75936502pasts
pasty105725052pasty
pate65350462pate_
pated85237842pated
paten74827342paten
pater74740722pater
pates76047892pates
patio74426352patio
pause75021832pause_
paused95114962paused
pauser84415962pauser
pauses84621472pauses
pave96133892pave_
paved115525262paved
paver104225832paver
paves104833922paves
pawed115725612pawed
pawer104422972pawer
paxes144928422paxes
payed115925932payed
payee105524722payee
payer105125722payer
pease75231112pease_
peasen84815962peasen
peases85229472peases
peso66925822pes_o
pesto75723722pesto
phase104617212phase_
phased124011972phased
phases114618402phases
pisco96314982pisco
piso66727562pis_o
pose66441732pose_
posed85828412posed
poser75128772poser
poses74642762poses
prase76128752prase_
prases84429022prases
puses75532202puses
rase46149982rase_
rased65033932rased
raser55633412raser
rases55447212rases
upases84112902upases
vase75629652vase_
vases84626262vases

Search took 4 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.1731032896.0
2DLD Change Limit538001313.29616322.8
3Display Results1311310.0304366.7
 (SQL Overall)1786911313.49951069.2
 
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.