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

142 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
pelican113943(None) 
pelicans1238091pelicans
pemican1348161pemican
helical12311152helical
helicon1237642helicon
pecan91919032pe__can
pedicab1446692pedicab
pemicans1447042pemicans
pemmican1643052pemmican
plica9613372p_lica_
plicae10410952p_licae
plical10411682p_lical
publican1444542publican
abelian92810643abeli_an
aeolian738623aeoli_an
allicin949953allicin
aphelian1376963apheli_an
applicant1545443applicant
bellman1137183bellman
celiac101910433celi_ac
celiacs11157893celiacs
colicin11313743colicin
delicacy1644253delicacy
delicate11315493delicate
delict94320333delic_t
delicts104012253delicts
elan46734243_el__an
elicit8417203_elicit
eolian6312593eoli_an
epical10413393_epical
erica7316543_erica_
ericas8315463_ericas
gallican1155333gallican
gelcap1136213gel_cap
glucan936183_glucan
glycan1234903_glycan
heliac111010893heli_ac
heliacal1344723heliacal
helices12313723helices
helicons1337613helicons
helipad1344723helipad
hellcat12410173hellcat
indican1048243indican
jerrican1794123jerrican
kalian10312163kali_an
lexica1536103lexica_
lexical1637363lexical
lexicon1643903lexicon
ligan67920283__ligan
liman75921603__liman
median94117543medi_an
medical12312513medical
medicant13910833medicant
melic94722333melic__
mesian84315503mesi_an
metical11315363metical
oilcan837793oil_can
paisan84417073p_aisan
palikar1335453palikar
parian83223963pari_an
pean66147173pe___an
pecans101515833pe__cans
peccant13311733pe_ccant
pechan13511543pe_chan
pedicabs1544593pedicabs
pedicel1237813pedicel
pedicle1238973pedicle
pedocal1237893pedocal
pein65834943pe_i__n
pekan111613973pe__kan
pekin111514423peki__n
pelisse967063pelisse
pelite84323003peli_te
pelites93821993pelites
pelitic111814653pelitic
pellicle1245043pellicle
pelon74423213pel__on
pelorian1048883pelorian
pelota8612833pelota_
pelotas9410723pelotas
peloton938743peloton
pelvic13307553pelvic__
pelvics14245643pelvic_s
pemmicans1742443pemmicans
penial84120893peni_al
penicil1138833penicil
penman10312323pe_nman
pericarp1446123pericarp
perigean1146353perigean
perigon1039853perigon
permian112612283permian
pian66136093p__i_an
pica85831493p__ica_
pical95524373p__ical
picas94626523p__icas
plan65833943p_l__an
platan83913693p_latan
pleiad947833plei_ad
pliant83918823p_li_ant
plicate11314513p_licate
poetical12311533poetical
polecat11313143polecat
police102918563polic_e
policed123212233policed
policeman1543263policeman
policer113112683policer
polices113118053polices
policing13311673policing
policy133211513polic_y
pollical1247953pollical
predicant1449393predicant
ptisan8417973p_tisan
publicans1544113publicans
pulicene1245723pulicene
pullman1135403pullman
puritan939283puritan
reliant7319243reli_ant
relic74623363relic__
relics84517903relic_s
relict83623903relic_t
relicts94414593relicts
reloan6415693rel_oan
replica1137943replica_
replicas1237093replicas
replicon1244323replicon
salicin9311223salicin
seitan62613233se_itan
sericin9312843sericin
silica8311243silica_
silicas9310603silicas
silicon9117533silicon
spelaean1043213spelaean
spelean937123spel_ean
teleman959573teleman
teleran7510183teleran
telia55821143teli_a_
telial65815363teli_al
telic76019823telic__
vesica11157913vesica_
vesicae12177703vesicae
vesical12159813vesical
vesicant1347503vesicant

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.436409841.7
2DLD Change Limit1340271426.56320421.6
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.06225303.2
 
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.