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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
paseos8801581(None) 
pareos87023771pareos
paseo77022511paseo_
pases75346501pase_s
apses76823912apse_s
askos95011772_askos
bases75644352base_s
bassos85313702bassos
cameos105818002cameos
caseose939162caseose
caseous9312512caseous
cases75048382case_s
easels65914552easels
eases56041612ease_s
gaseous839502gaseous
gases65633992gase_s
lasers64925702lasers
lases54944762lase_s
lassos64913812lassos
masers84623452masers
oases55330982oase_s
pacers105124542pacers
paces96741112pace_s
paeon74819492pa_eon
paeons83915522pa_eons
pagers94423252pagers
pages85235072page_s
pales75753802pale_s
palets85122312palets
panels84716522panels
panes76148692pane_s
pantos85222742pantos
papers105125322papers
pareo74632602pareo_
parers85530742parers
pares77164482pare_s
pareus85420742pareus
pargos95719042pargos
parsecs11429922parsecs
parsers94118152parsers
parses85534702parse_s
parvos116614752parvos
pase65346862pase__
pashas115117062pashas
pashes115828392pashes
pass65239952pas__s
passels93913022passels
passers94717752passers
passes86030472passes
passus83610292passus
pastas85422872pastas
pastels95215182pastels
pasters94531732pasters
pastes85233912pastes
pastis84924322pastis
pastor84817482pastor
pastors94119002pastors
pasts75936502pas_ts
patens84820862patens
paters84935832paters
pates76047892pate_s
pathos115516692pathos
patios85221782patios
pausers94113222pausers
pauses84621472pause_s
pavers115021822pavers
paves104833922pave_s
pawers114818782pawers
paxes144928422paxe_s
payees114812902payees
payers114621822payers
peases85229472pease_s
pesos77221622pes_os
pestos84719082pestos
phases114618402phase_s
piscos105112592piscos
pisos76021062pis_os
posers84223972posers
poses74642762pose_s
prases84429022prase_s
puses75532202puse_s
rasers64526782rasers
rases55447212rase_s
upases84112902upase_s
vases84626262vase_s

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 Filter178691825510.360496363.9
2DLD Change Limit82551852.54632423.8
3Display Results85850.0302833.3
 (SQL Overall)178691852.93660862.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.