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

278 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
peeler83517381peeler_
peelers93615591peelers
feeler93215172feeler_
feelers103814742feelers
heeler93917312heeler_
heelers103815622heelers
pedler93614622pedler_
pedlers103013272pedlers
pedlery13297082pedlery
peeled94119712peele_d
peeper103614802peeper_
peepers113713672peepers
pellet83326552pelle_t
pervert12315582pervert
preelect1249642preelect
prelect111013832prelect
reelect911515632reelect
reeler63822572reeler_
reelers73520272reelers
alert54740653__alert
beeper103714093beeper_
beepers113612383beepers
beetler938043beetler_
beetlers1037403beetlers
beezer174010523beezer_
beezers18349243beezers
beveler124010693beveler_
bevelers13389463bevelers
ceiler84013963ceiler_
ceilers93912533ceilers
celery1139623_celery
coexert16312363coexert
dealer74122143dealer_
dealers84118613dealers
deeper93613503deeper_
deepest10310443deepest
deflect13399973deflect
deselect1147523deselect
desert72725493_desert
dessert82916453dessert
dueler74213683dueler_
duelers83412053duelers
eelier64216463_eelier_
eeliest73516473_eeliest
elect74327033__elect
evert84929513__evert
exert124624143__exert
expert15515353_expert
exsert13414363_exsert
eyelet9514533eyele_t
feebler1235823feebler_
feeblest1336913feeblest
feeder103513843feeder_
feeders113712863feeders
feeless103511103feeless
feller94419553feller_
fellers104117543fellers
fellest10313753fellest
fueler94313933fueler_
fuelers103912393fuelers
geezer16278013geezer_
geezers17286513geezers
healer94221803healer_
healers104319463healers
heeder104216043heeder_
heeders114213743heeders
heeled104018413heele_d
heller93322513heller_
helleri10389973helleri
hellers103619833hellers
hellery13329213hellery
jeepers16399193jeepers
jeerer13389933jeerer_
jeerers14328923jeerers
jeweler1735053jeweler_
jewelers1834713jewelers
keeled114414273keele_d
keener104012843keener_
keeners113610783keeners
keenest11410963keenest
keeper123811923keeper_
keepers133410983keepers
kegeler1245493kegeler_
kegelers1355163kegelers
kegler11398243kegler_
keglers12277773keglers
kneeler11277573kneeler_
kneelers12226213kneelers
leveler10399903leveler_
levelers11259323levelers
meeker12359983meeker_
meekest1336893meekest
meeter83616503meeter_
meeters94714543meeters
mewler113510233mewler_
mewlers12288983mewlers
needer73614953needer_
needers84111903needers
needler8388893needler_
needlers9287423needlers
neglect1047363neglect
omelet8317073omele_t
paler75436933p_aler_
palest83926223p_alest
palet74650803p_ale_t
pallet84232653palle_t
pealed95322813peale_d
pearler9310373pearler_
pearlers1039033pearlers
peart76440753p_e_art
pecker144615363pecker_
peckers153312673peckers
pedaler103410693pedaler_
pedalers11239393pedalers
peddler113210493peddler_
peddlers12298533peddlers
peddlery15224013peddlery
pedlar93311273pedlar_
pedlars103210213pedlars
pedlary13277543pedlary
peebeen1143903peebeen
peeked134314583peeke_d
peel65535613peel___
peeling102919873peeling
peels75226423peel__s
peened94318163peene_d
peeped113915393peepe_d
peer66238353p_e_er_
peered93819493peere_d
peeress939503peeress
peerless1037513peerless
peers75130273p_e_ers
peery105719443p_e_ery
peetweet1344973peetweet
peeve104915253peeve__
peeved124112893peeve_d
peeves113814873peeve_s
peewee11311963peewe_e
peewees1236803peewees
peewit111110903pee_wit
pegless1038053pegless
pele65539553p_ele__
peles75738083p_ele_s
pellets94014783pellets
pelmet103419243p_elmet
pelt67651083p_el__t
pelter83321623pelter_
pelters93720313pelters
peltry11288653p_eltry
pendent10314723pendent
penner84616663penner_
penners93414183penners
peopler1138083peopler_
peoplers1237163peoplers
pepper93512943pepper_
peppers103311443peppers
peppery13286253peppery
percent113520603percent
percept133112523percept
perfect141010833perfect
perpent112318813perpent
pert66759323p___ert
perter84422283perter_
pertest9317043pertest
perverts1337533perverts
pester84827593pester_
pesters93827093pesters
peter74427593p_eter_
peters86624593p_eters
petter83924773petter_
petters93722363petters
pewter114013673pewter_
pewters124113353pewters
piecer105213083piecer_
piecers114112253piecers
piefort1249533piefort
piglet93420923pigle_t
piolet83225643piole_t
pleat74734473p__leat
poler74431793p_oler_
polers84225643p_olers
poller83921853poller_
pollers93420023pollers
pooler83819843pooler_
poolers94217423poolers
praelect1247533praelect
precent113520263precent
precept133112513precept
preelects1356083preelects
preener93114833preener_
preeners102712813preeners
preerect1259273preerect
prefect141011073prefect
prefer113813203prefer_
prefers123713333prefers
preheat12413893preheat
prelects1299723prelects
premeet11615153premeet
preselect1346983preselect
present94022733present
preset84430983prese_t
presort95219543presort
preterit10315843preterit
preterm11310163preterm
pretest9517633pretest
pretext1639663pretext
prevent124016553prevent
preverb14317063preverb
preyer114413733preyer_
preyers124412363preyers
puler74826623p_uler_
pulers83820283p_ulers
puller83820813puller_
pullers93618483pullers
pullet84026333pulle_t
realer63528593realer_
realest73322433realest
reblent9614253reblent
reefer93314363reefer_
reefers103312593reefers
reeject16349623reeject
reeker103715593reeker_
reekers113613143reekers
reelects103110883reelects
reeled74725533reele_d
reerect92915883reerect
reflect123913713reflect
reflet94024233refle_t
reglet73724233regle_t
relent64431853_relent
relet54749823_rele_t
reselect1059943reselect
reveler104116343reveler_
revelers113414133revelers
revert93529113_revert
sealer63928963sealer_
sealers74323553sealers
sealery104011053sealery
seeder74320773seeder_
seeders83017113seeders
seeker103615363seeker_
seekers113712333seekers
seeled73922093seele_d
seemer84418043seemer_
seemers93814333seemers
select82621173_select
seller63824603seller_
sellers73721323sellers
sievert10613293sievert
speeder103811073speeder_
speeders11339313speeders
speeled103712453speele_d
speller95415153speller_
spellers102812763spellers
spieler93111233spieler_
spielers10319653spielers
teemer85515743teemer_
teemers95012903teemers
teener64717503teener_
teeners74415453teeners
teeter65420313teeter_
teeters74018303teeters
teller63519823teller_
tellers73717603tellers
vealer94016543vealer_
vealers103214293vealers
veiler93814353veiler_
veilers103911823veilers
weeder103315513weeder_
weeders113412933weeders
weeper114313303weeper_
weepers123511973weepers
weever123811443weever_
weevers13379993weevers
wheeler13298773wheeler_
wheelers14287733wheelers
yeller94214513yeller_
yellers103912953yellers

Search took 8 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.390458182.1
2DLD Change Limit1340272787.18618651.1
3Display Results2782780.1102527.3
 (SQL Overall)1786912787.68623248.9
 
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.