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

197 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
pareo7463260(None) 
pare66760841pare_
pared86946761pared
pareos87023771pareos
parer75839901parer
pares77164481pares
pareu74928741pareu
pargo86723721pargo
parvo107719181parvo
paseo77022511paseo
aero45435342_aero
aparejo16113522aparejo
apres75426402apres
arco68331542_arco
are37874572_are_
area45843392_area
ares45871022_ares
arvo76023432_arvo
bare65460522bare_
bared85144482bared
barer74535802barer
bares75457132bares
cameo95924992cameo
carbo94923842carbo
care66968372care_
cared86050092cared
carer74942332carer
cares77369182cares
caret75360562caret
carex144822302carex
cargo85322072cargo
dare55848862dare_
dared75935012dared
darer65230792darer
dares66146702dares
eared65139502eared
fare76354462fare_
fared95842342fared
farer86733142farer
fares85852872fares
faro76136922far_o
hare76255732hare_
hared95742182hared
harem104924452harem
hares86255542hares
karoo92519582karoo
laree56036292laree
lares54852632lares
largo65319782largo
mare64759332mare_
mares76457632mares
narco76718242narco
nares55544152nares
oared65030652oared
pace86345772pace_
paced106931682paced
pacer96131612pacer
paces96741112paces
pacey126720282pacey
padre86018162padre_
padres95016982padres
paeon74819492pa_eon
page76036102page_
paged95926782paged
pager84728202pager
pages85235072pages
paired95017522paired
pale66055012pale_
palea75028662palea
paled85538722paled
paler75436932paler
pales75753802pales
palet74650802palet
pane64950292pane_
paned85437182paned
panel76023622panel
panes76148692panes
panto76129412panto
paper95128662paper
par57467022par__
para65242172par_a
parae76335702parae
paramo102614642paramo
paras76143042paras
parcel103915472parcel
parch125123002parch
pard76441322par_d
pardee93922022pardee
pardi85723952pardi
pardon94618732pardon
pards85634332pards
pardy115523952pardy
parent83230422parent
parers85530742parers
pareus85420742pareus
pareve114613012pareve
parge85831852parge
parged104922042parged
parges94529542parges
parget94529392parget
pargos95719042pargos
paries84742512paries
paris75145942paris
park105237492par_k
parka115120882parka
parked134425142parked
parker124121372parker
parks116134462parks
parle75836162parle
parled94626292parled
parles86334402parles
parley116718362parley
parlor8312672parlor
parol74826272parol
parr65731152par_r
parred95024072parred
parrel84515982parrel
parrot8320662parrot
parrs75928672parrs
parry105323752parry
pars67560792par_s
parse75236992parse
parsec105914482parsec
parsed96323892parsed
parser84822372parser
parses85534702parses
parson83817902parson
part65967462par_t
parted94228682parted
parton84720992parton
parts77743372parts
party106630612party
parve109824852parve
parvos116614752parvos
pase65346862pase_
paseos88015812paseos
pases75346502pases
pate65350462pate_
pated85237842pated
paten74827342paten
pater74740722pater
pates76047892pates
patio74426352patio
pave96133892pave_
paved115525262paved
paver104225832paver
paves104833922paves
pawed115725612pawed
pawer104422972pawer
paxes144928422paxes
payed115925932payed
payee105524722payee
payer105125722payer
pere66450262pere_
perea75026442perea
pereon83517452pereon
peres76246642peres
pore66451262pore_
pored85234512pored
pores75849032pores
porno75120652porno
prao66229022p_rao
pree67044732p_ree
preop94715872p_reop
prep86427672p_rep
prex135722972p_rex
prey96228482p_rey
prez156126312p_rez
pro55837262p_r_o
pure65543332pure_
puree74632842puree
purer75127902purer
pyre94925552pyre_
pyres105523882pyres
pyrex175211212pyrex
pyro96019392pyr_o
rare45348432rare_
rared65738322rared
rarer54731702rarer
rares55247442rares
saree55044662saree
sargo65424412sargo
spare75135562spare_
spared95427492spared
sparer84524962sparer
spares84834552spares
tardo65321102tardo
tare45957622tare_
tared69340052tared
tares57456562tares
taro46846912tar_o
vireo84816452vireo
ware76254722ware_
wared96339872wared
wares88250582wares
yare75636942yare_
yarer84321572yarer

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.346516448.0
2DLD Change Limit538001971.65332546.9
3Display Results1971970.0464282.6
 (SQL Overall)1786911972.04587379.5
 
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.