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

260 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
pion6723529(None) 
cion613330911cion
ion36051021_ion
lion46334441lion
peon65635241peon
phon95925381phon
pian66136091pian
pin57066721pi_n
pinon76024531pinon
pions75826391pions
pirn67128371pirn
piton76121581piton
poon67341261poon
prion75119991prion
aeon45634612aeon
agon56531882agon
ain37579092ai_n
airn46433832airn
anion55028812anion
anon46134852anon
apian75018332apian
apron7318832apron
avion84218342avion
axion1211316912axion
axon115524302axon
azon135725052azon
bin56658642bi_n
bio57846082bio_
biog76122322biog
biont7727162biont
bios66335322bios
bison75716982bison
boon67142172boon
chon96627792chon
cions75222852cions
clon66232482clon
coin66645352coin
con510268022_con
coon67248942coon
din46459462di_n
dino56036752dino
diol57329132diol
don46757652_don
ebon66821102ebon
eikon939462eikon
eon36052082_eon
epigon937962epigon
exon117116802exon
fin66458032fi_n
fino76034692fino
firn76927502firn
foin77231562foin
fon66352272_fon
gien56330022gien
gin46055752gi_n
gipon84212412gipon
girn56026862girn
giron66118992giron
goon57236172goon
hin67559562hi_n
hisn79620932hisn
hon67759382_hon
icon66922042icon
ikon85814952ikon
in28150862_i_n
inion54620182inion
inn36727432_inn
ions46737852_ions
iron46728462iron
jeon116821442jeon
jin106443932ji_n
jinn115420242jinn
join116724832join
kaon87521022kaon
kiln85620982kiln
kin76353972ki_n
kino86233622kino
kirn87123442kirn
lien45339802lien
limn66527692limn
lin37967372li_n
linn46034592linn
lino46343372lino
lions55923212lions
loin46838722loin
loon47344792loon
mien65028362mien
mon57561582_mon
moon67140812moon
muon65722732muon
neon47026422neon
ninon55517382ninon
niton55418282niton
noon47134622noon
on28057182__on
onion54320972onion
option83612712option
paeon74819492paeon
pain65647242pain
pan58466452p_an
pawn94625302pawn
pean66147172pean
peen65938082peen
pein65834942pein
pelon74423212pelon
pen56558842p_en
peons75327182peons
peony105717562peony
phone105621932phone
phono104917022phono
phons105221142phons
phony136715442phony
phot95534362phot
pi48145362pi__
pia56848032pi_a
pial65636702pial
piano76118712piano
pians75126962pians
pias66542552pias
pic76046822pi_c
pica85831492pica
pice84641092pice
pick125933812pick
picot95031012picot
pics85633912pics
pie55457402pi_e
pied75035362pied
pier66035292pier
pies66949602pies
pig65744972pi_g
pigeon949412pigeon
pigs76634222pigs
piing85218832piing
pika106322952pika
pike106335212pike
piki106520562piki
pile65649692pile
pili66130352pili
pill65339462pill
pilot77435062pilot
pily96132732pily
pima85428652pima
pimp106024902pimp
pina65842632pina
pine67755712pine
ping75943592ping
pinion83815892pinion
pink107039382pink
pinna75320182pinna
pinny105222062pinny
pinons86019942pinons
pinot78737292pinot
pins65558452pins
pint66963172pint
piny911838352piny
pinyon11459762pinyon
pionic103515952pionic
pious74621272pious
pip78051042pi_p
pipe86434432pipe
pips85837132pips
pipy115421512pipy
pirns76020092pirns
pirog83913672pirog
pis56362032pi_s
pish96127912pish
piso66727562piso
pisos76021062pisos
piss65033332piss
piston83515922piston
pit56471922pi_t
pita65436432pita
pith95432692pith
pitons85319042pitons
pits66348742pits
pity96031932pity
piu56639542pi_u
pivot106523872pivot
pix126437932pi_x
pixy166117762pixy
plan65833942plan
pleon74216382pleon
plod76723272plod
plonk114613982plonk
plop86625742plop
plot66141232plot
plow95923232plow
ploy96123602ploy
pod66351482p_od
poh86740532p_oh
poi57244662p_oi
poind84217912poind
point75338732point
pois66539042pois
poison8312222poison
pol56449382p_ol
pom78249912p_om
pond75530492p_ond
pone65747532p_one
pong76231142p_ong
pons65850602p_ons
pony96434052p_ony
poo57757112p_oo
pood75934322pood
poof95541662poof
pooh96027382pooh
pool65835952pool
poons75430972poons
poop86532812poop
poor65630222poor
poos65949112poos
pop76252252p_op
porn65636022porn
pot58078432p_ot
potion84519572potion
pow87147282p_ow
pox126140692p_ox
prions84317782prions
prior74316172prior
prison8514022prison
pro55837262pro_
proa66229962proa
prod76129502prod
prof96134662prof
prog75729002prog
prom87631702prom
prone75332622prone
prong85218112prong
prop85932812prop
pros65742782pros
prow97030382prow
pun58846512p_un
puton73617912puton
pyin96823232pyin
pylon103614002pylon
rin36663182ri_n
riot45947212riot
scion72214992scion
sign55523052sign
sin36265892si_n
son37761952_son
soon46240502soon
spin66231302spi_n
spoon74719442spoon
tigon63914442tigon
tin36362172ti_n
ton310265102_ton
toon47740632toon
udon56017742udon
union54519792union
upon65817582upon
vino76128432vino
viol76523592viol
win66456292wi_n
wino75933612wino
won66252062_won
yin67648732yi_n
yon67348952_yon
zin125643772zi_n
zoon137326982zoon

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298722600.76638997.4
3Display Results2602600.0604333.3
 (SQL Overall)1786912601.106161565.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.