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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

191 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
parador10331141(None) 
parader103914861parader
paradors113411901paradors
parados103816051parados
paradox17358171paradox
ardor64617862_ar_dor
labrador1143882labrador
matador1066252matador
mirador1046502mirador
papadom1466762papadom
parachor1546662parachor
parade94720642parad_e
paraded114014262paraded
paraders113113122paraders
parades104121472parades
paradores12259672paradores
paradrop1344602paradrop
paraform1546932paraform
paragon10311022paragon
paramo102614642paramo_
paramos113213512paramos
paramour1246082paramour
parasol939552parasol
pardon94618732par_don
parlor8312672par_lor
parodoi10267722parodoi
parodos103011752parodos
picador1245922picador
abator84512723_abator
abrader1038643abrader
aerator7314843aerator
amadou977613_amadou
arbor74818113_ar_bor
ardors74416873_ar_dors
ardour74110903_ar_dour
arider74717743_arider
armor75118053_ar_mor
bahadur1342603bahadur
barrator1048403barrator
candor94516423ca_ndor
caracol11310423caracol
carder94524183car_der
cardon94120853car_don
chador1238673_chador
curator9312213curator
dorado838813dorado_
dorados938203dorados
earldom1044583earldom
farad95720673farad__
faraday1445633faraday
faradic1337693faradic
farads104713273farad_s
grader84919693_grader
gyrator1135723gyrator
harbor11410723har_bor
harder105022403har_der
jarldom1743123jarldom
labradors1243793labradors
larder73720973lar_der
lardon74415063lar_don
malodor1044563malodor
marabou1147493marabou
marauder1144553marauder
markhor1635463markhor
matadors1156983matadors
miradors1146853miradors
narrator847563narrator
operator10310093operator
orator6314533_orator
pachadom1844183pachadom
padder103415493pa_dder
pagandom1443533pagandom
paladin101011773paladin
palaver1238753palaver
pallor8313673pa_llor
palpator1247133palpator
panada94113053panad_a
panadas103312213panadas
pander93725523pa_nder
pandoor10358583pandoor
pandora1039543pa_ndora
pandore10411853pa_ndore
pandour10408213pa_ndour
papadam1486913papadam
papadoms1575923papadoms
papadum1475233papadum
para65242173para___
parable111819783parable
parabola1246663parabola
parachors1647413parachors
paradigm1446243paradigm
parading12313863parading
paradise112113873paradise
paradoses122510263paradoses
paradoxes19267303paradoxes
paradrops1444963paradrops
parae76335703para__e
parafoil1345973parafoil
paraforms1645573paraforms
paragoge1257153paragoge
paragons11311513paragons
paramorph1844333paramorph
paramours1345663paramours
parang93715513para_ng
parangs104314383parangs
paranoea1048583paranoea
paranoia10410573paranoia
paranoic1249833paranoic
paranoid11311143paranoid
parapet11317643parapet
paraph13311263para_ph
paraphs1439313paraphs
paras76143043para__s
parashot13410143parashot
parasols1039273parasols
parazoan1946553parazoan
pard76441323par_d__
pardah123412823par_dah
pardahs13289673pardahs
pardee93922023par_dee
pardi85723953par_d_i
pardie96021443par_die
pardner10239473pardner
pardoner11189443par_doner
pardons103817623par_dons
pards85634333par_d_s
pardy115523953par_d_y
pared86946763pared__
pareo74632603par_eo_
pareos87023773par_eos
parer75839903par__er
pargo86723723par_go_
pargos95719043par_gos
parkade1437583parkad_e
parkades1538273parkades
parker124121373par_ker
parlando1145413parlando_
parlors9312913par_lors
parlour937263parlour
parodic122311723parodic
parody12410093parod_y
parol74826273par__ol
parr65731153par___r
parrier93717653parrier
parrot8320663par_rot
parser84822373par_ser
parson83817903par_son
partaker1436873partaker
partier93520713partier
partner92811393partner
parton84720993par_ton
partook1337313partook
partyer12337873partyer
parvo107719183par_vo_
parvos116614753par_vos
pashadom1643843pashadom
passado1037053passado_
passados1146303passados
pastor84817483pa_stor
patamar1147093patamar
pavior1138533pa_vior
pawnor11357243pa_wnor
payor105413843p__ayor
peridot10514243peridot
pervader1444863pervader
pharaoh1545033phara_oh
picadors1345853picadors
pleader103511753pleader
praetor938973praetor
prao66229023p_ra_o_
praos74923563p_ra_os
prater84825353p_rater
prayer114815293p_rayer
pretor8315753p_retor
prior74316173p_r_ior
radar61316723__radar
radon64620503__radon
razor143012603__razor
sardar73013173sar_dar
sartor6313883sar_tor
separator1146263separator
sordor7310223sor_dor
stridor8467393stridor
tardo65321103tar_do_
toreador945003toreador
trader75218763_trader
varactor1345703varactor
vavasor13143603vavasor
warder104020273war_der
warrior1045363warrior
yarder103813973yar_der

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit1340271916.44020811.6
3Display Results1911910.0603183.3
 (SQL Overall)1786911916.90325886.0
 
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.