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

277 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
pinyons1229900(None) 
pinions93413601pinions
pinons86019941pin_ons
pinyon11459761pinyon_
anyons94513502_anyons
canyons124511592canyons
inions64417002_inions
minions93314622minions
minyans1237262minyans
ninons64913772nin_ons
opinions1045932opinions
pennons939712pennons
pigeons1039182pigeons
pinbone1138182pinbone
pinbones1238142pinbones
pingoes105116522pingoes
pingos95317672pingo_s
pinion83815892pinion_
pinkens13419652pinkens
pinkoes135512312pinkoes
pinkos125313872pinko_s
pinon76024532pin_on_
pinones94717072pin_ones
pinots85920272pin_ots
pintoes95117712pintoes
pintos86021292pinto_s
pinyin112710612pinyin_
pions75826392pi__ons
pistons93016372pistons
pitons85319042pi_tons
pontons93315552pontons
ronyons10258432ronyons
amnions93710913amnions
anions64123033_anions
anyon85615223_anyon_
anyone94612733_anyone
banyans1237913banyans
baryons121010473baryons
bicrons113410473bicrons
billons93013363billons
bingoes104013983bingoes
bingos95514793bingo_s
binocs1039923bin_ocs
bisons83914373bi_sons
bonbons1139333bonbons
bunions92210473bunions
cannons94412883cannons
canons85522063can_ons
cantons95221203cantons
canyon114512033canyon_
cineols9128853cineols
cions75222853ci__ons
citrons92913223citrons
crayons12439233crayons
dingoes94114833dingoes
dinos65428063din_o_s
diurons838823diurons
donjons1536733donjons
eikons1038503ei_kons
einkorns1243343einkorns
epigons1048183epi_gons
epinaos936283epinao_s
fanions103713073fanions
fanons96115213fan_ons
finos86226953fin_o_s
gibbons1234983gibbons
gibsons1045043gibsons
ginzoes1735433ginzoes
gipons9389603gi_pons
girons75014373gi_rons
icons76516493_i_cons
ikons96311013_i_kons
incogs937903_incogs
incony1139083_incony
indols74714203_indols
indows104210793_indows
infos84311673_info_s
ingots7912063_ingots
inion54620183_inion_
inns46920933_in__ns
inruns6359513_inruns
intone61115433_intone
intones7816543_intones
introns73515023_introns
inurns63310983_inurns
ions46737853_i__ons
irons55324133_i_rons
jingoes153811443jingoes
jinns126013843jin__ns
kinins104014583kin_ins
kinos96626153kin_o_s
lindens839413lindens
linens64818393lin_ens
lingoes84014693lingoes
linins65922143lin_ins
linns56123333lin__ns
linos55631503lin_o_s
lintols7339553lintols
linurons846333linurons
lions55923213li__ons
microns113814783microns
midnoons1144403midnoons
mignons1037863mignons
mikrons13428413mikrons
minion83416243minion_
minnows1234913minnows
minors85117103min_ors
minyan1138173minyan_
neons55818683__neons
ninon55517383nin_on_
nitons64614903ni_tons
noons54125283__noons
nylons9267973__nylons
onions64016433_onions
opinion946793opinion_
paeons83915523p_aeons
pangens103112073pangens
pantos85222743panto_s
pardons103817623pardons
parsons93516873parsons
partons94620513partons
patrons93818103patrons
payors114312643p_ayors
pengos94612413pengo_s
pennon8310643pennon_
pensions10311693pensions
peons75327183p__eons
pereons92815003pereons
perrons93115483perrons
persons93717013persons
phonons123310253phonons
phons105221143p__hons
photons123814433photons
phytons15319063phytons
pianos84315933piano_s
pians75126963pi__ans
piceous11310693piceous
picots104616443pi_cots
pidgins11259123pidgins
pigeon949413pigeon_
piggins113010473piggins
pigpens1235503pigpens
pileous9510523pileous
pillions101610933pillions
pillows122610123pillows
pilots84018873pi_lots
pilous84717753pi_lous
pinang92611593pin_ang
pinangs10267793pinangs
pinas75434453pin__as
pinatas93711503pinatas
pincers113916503pincers
pinches144117943pinches
pinders103720483pinders
pineals93212853pineals
pinecone1246063pinecone
pinecones1346253pinecones
pinene82915653pin_ene
pinenes93416693pinenes
pines76048863pin__es
pinfold1336233pinfold
pinfolds1445143pinfolds
pingers104020743pingers
pinging113419553pinging
pingo87122713pingo__
pings85830883pin__gs
pinhole122010433pinhole
pinholes131810663pinholes
pining93726533pin_ing
pinioned1137513pinioned
pinites9319533pinites
pinitols1046103pinitols
pinken124513283pinken_
pinkers134118603pinkers
pinkeys16378213pinkeys
pinkies133818263pinkies
pinking143918943pinking
pinkings15338143pinkings
pinko115618253pinko__
pinks115729383pin__ks
pinna75320183pin__na
pinnas85315523pin_nas
pinners93518603pinners
pinnies93318443pinnies
pinning103417853pinning
pinny105222063pin__ny
pinole83218783pin_ole
pinoles93418713pinoles
pinot78737293pin_o_t
pinpoint1248993pinpoint
pinpoints1344153pinpoints
pins65558463pi___ns
pintano998993pintano
pintanos10107553pintanos
pintas85021393pin_tas
pintles94118733pintles
pinto75625753pinto__
pints75936223pin__ts
pinups1037413pin_ups
pinwork16107243pinwork
pinworks17106353pinworks
pinworm1467183pinworm
pinworms15115783pinworms
piny911838363piny___
pion67235303pi__on_
pious74621273pi__ous
pipkins15328183pipkins
pippins10319753pippins
pirns76020093pi__rns
piscos105112593pisco_s
pisos76021063pi_so_s
pistols93213983pistols
piston83515923piston_
pistous92714383pistous
piteous9310683piteous
pitmans11188743pitmans
piton76121583pi_ton_
pitying132910243pitying
pivots115111903pi_vots
pleons84213343p_leons
plutons938343plutons
poisons9310353poisons
polygons1447723polygons
polyols1238493polyols
pompons1338553pompons
pons65850603p___ons
ponton83217643ponton_
pontoons10279313pontoons
ponying133312123ponying
poons75430973p__oons
potions93417423potions
poyous112911623p_oyous
prions84317783p_rions
prisons9313223prisons
protons93118003protons
psyops1334343p_syops
punkins133111113punkins
puntos85915793punto_s
putons83515153p_utons
pyins105815863p__yins
pylons113011243p_ylons
pythons1537363pythons
rayons94113343_rayons
ribbons1136253ribbons
ronions73313343ronions
ronyon9309133ronyon_
simoons937943simoons
sinuous739063sinuous
siphons1239353siphons
spinors939423spin_ors
spinous9310443spin_ous
spintos939133spinto_s
sponsons1045813sponsons
tendons8311473tendons
tenons62916603ten_ons
tiglons837343tiglons
tigons74112263ti_gons
tinhorns1145013tinhorns
toyons95512133_toyons
unions64216753_unions
unisons748423unisons
vinos84723073vin_o_s
vinous93914173vin_ous
vinyls12467003viny_ls
virions1039873virions
visions10311023visions
wanions104011373wanions
wantons103713013wantons
wigeons1136983wigeons
windows1447743windows
winnows1334533winnows
winoes94317013win_oes
winos84625043win_o_s
wontons103310533wontons
xenons132710483xen_ons
zincous1837053zincous
zircons1854963zircons

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.403443402.0
2DLD Change Limit1340272776.84619577.4
3Display Results2772770.1102518.2
 (SQL Overall)1786912777.35924282.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.